View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
xlm[_2_] xlm[_2_] is offline
external usenet poster
 
Posts: 29
Default Conditional Format

Hi Stew

Select Cells C10:E10, then apply your conditional format.
The conditional format should work on all these cells. If not, pls post back

--
HTH
Appreciate that you click the Yes button below if this posting is helpful

cheers, francis

"stew" wrote in message
...
Happy New Year to all

This Formula in conditional format only works in Respect to C10.

I am trying to achieve that if a number is placed in any of these cells
the
conditional format is true

=ISNUMBER(C10:E10)

What is my mistake

Best

Stew