Conditional Format
 

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

Use formula is and

=COUNTIF(J1:O1,B3)0

--

Regards,

Peo Sjoblom

"George Gee" wrote in message
...
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

Many thanks, the formula is spot on!

George Gee

*Peo Sjoblom* has posted this message:

Use formula is and

=COUNTIF(J1:O1,B3)0

--

Regards,

Peo Sjoblom

"George Gee" wrote in message
...
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