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
No comments:
Post a Comment