Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
How to create a conditional format that changes the number format | Excel Discussion (Misc queries) | |||
Conditional Format - Format Transfer To Chart | Excel Discussion (Misc queries) | |||
copy conditional format to regular format | Setting up and Configuration of Excel | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |