Sunday, April 13, 2014

yogi_Check To Which Cells In The Selected Range Has Conditional Formatting Been Applied To


                                         Google Spreadsheet   Post  #1601
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Apr-12-2014
post by Stanley Watson: (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/Nq6akInalUU)
How to view which cells have conditional formatting
Just like the question topic, is there an easy way to see exactly which cells have conditional formatting, and which don't? Or do I have to click on each one?

Thank you for any advice...
--------------------------------------------------------------------------------------------------------------------------------------------------------

     if you select a specific range or for that matter even the entire sheet, then
     right click and select Conditional Formatting a dialog box would pop up and
     show all the Conditional Formatting rules used in that range ...
     from those rules one can see which cells have Conditional Formatting applied to them
     (this is an indirect way of looking at which cells have Conditional Formatting applied to them)

as you will notice I had selected the range A:T ... then on right clicking and clicking on Conditional Formatting
a dialog box popped up that shows all the Conditional Formatting rules that have been used in that range ...




then what I have to do is scan the table, look at 

1) the rules, 
2) the cell the Conditional Formatting has been applied to, and
3) the ranges each of the Conditional Formatting rule applies to

so, as you can see that is why I had said this is an indirect way of determining which cells have Conditional Formatting applied to them