Previous Topic Next Topic

Conditional formatting

Closed
Taffy - Aug 7, 2015 at 04:34 AM
Hello,
I need dates to be highlighted if over 6 months but to clear again if marked Y (completed) in another cell? I can obviously get the 6 month due to change but cant get it to change back if marked completed?

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
Conditional format based on another cell containing text
stakik -
Corrina66 -

5 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Conditional formatting with multiple rules and blank text cells
PaiviM -
PaiviM -

6 responses
one cell will turn green when the two other cells match
diestra123 -
diestra123 -

13 responses