1

As far as I can tell, in Google Sheets you only see a list of formatting rules applying to your current selection. Is there a way to see a list of all rules that exist in a sheet? When people copy-paste between cells they often mangle these rules and this would make fixing it easier.

2

Select All (Ctrl+A) and go to FormatConditional Formation.

This will show you every active conditional formatting rule even if some cells are hidden.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.