Conditional Format
 

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

Conditional Format
 

=count(c10:e10)0



stew wrote:

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

Conditional Format
 

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)

Conditional Format
 

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


barry houdini wrote:

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

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

Conditional Format
 

Thanks all

Stew

"xlm" wrote:

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