Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Example:
Cells A1:A4 have conditional formatting set up that states if they are equal to cell A10 they will be highlighted yellow. Is there a way to quickly see what cells drive conditional formatting? In other words, we can use Edit - Go To Special to see which cells have conditional formatting applied; however, this doesn't show us that A10 is involved. Since there isn't a formula directly involved, we can't trace precedents/dependents. Can we only know that A10 is involved in the formatting of A1:A4 by selecting those cells and going into the conditional formatting dialog box? Is there another, faster way? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
How do I get more than 3 Conditional formatting? | Excel Discussion (Misc queries) | |||
Print cells that meet conditional formatting criteria | Excel Discussion (Misc queries) | |||
Adding more than three Conditions to 'Conditional Formatting' | Excel Discussion (Misc queries) | |||
Cells losing formatting | Excel Discussion (Misc queries) |