Conditional Format

George Gee · Feb 17, 2005

Hi all,

Can someone help me with this conditional format problem?

I am trying to express the following:

If the number in cell B3 can be found in the range J1:O1,
then the condition is true.

The number in B3 is constant (35), the values in range J1:O1
change weekly.

Many thanks

George Gee

Peo Sjoblom · Feb 17, 2005

Use formula is and

=COUNTIF(J1:O1,B3)>0

George Gee · Feb 17, 2005

Peo

Many thanks, the formula is spot on!

George Gee

*Peo Sjoblom* has posted this message: