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
|