Conditional Format

[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

 

[Dave Peterson]

=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

 

[barry houdini]

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)

 

[Dave Peterson]

Or
=count($c$10:$e$10)

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)

 

[xlm]

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

 

[stew]

Thanks all

Stew

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