Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Hello Excel(lent) Colleagues,
I am looking for the following way of conditional formatting. I have a row in which field A1 contains a text. B1 contains a date C1 contains the date of B1+7 days D1 contains the date of C1+7 days E1 contains the date of D1+7 days I want to mark the text in A1 with a particular colour if any of the date fields is marked with an X. I tried to work with: Formula is : =IF($C$3:$H$3="X";TRUE;FALSE) The effect of this is that only if you cross B1 it will turn a different colour, but if you move that cross from B1 to say E1, the colour dissapears, were it should stay. Please help me !! -- ** Fool on the hill ** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |