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.

1 Answer 1


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

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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