Conditional Format

  • Thread starter Thread starter stew
  • Start date Start date
S

stew

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
 
=count(c10:e10)>0


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
Click to expand...
 
Which cells are you trying to format? You might need to "fix" the cell
references if you want to format multiple cells, e.g. if you are
trying to format C10:E10 based on that condition then select those
cells and use

=COUNT($C10:$E10)
 
Or
=count($c$10:$e$10)


barry said:
Which cells are you trying to format? You might need to "fix" the cell
references if you want to format multiple cells, e.g. if you are
trying to format C10:E10 based on that condition then select those
cells and use

=COUNT($C10:$E10)
Click to expand...
 
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
 
Thanks all

Stew

xlm said:
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
Click to expand...
 
Back
Top