Hi jay

Try
=COUNTIF(C1:E1,"x")0

Regards

Roger Govier


Jaydubs wrote:
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 !!