Conditional Format

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
 
D

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
 
B

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)
 
D

Dave Peterson

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)
 
X

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
 
S

stew

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top