View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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