Wooksheet setup

[Mark]

?? Is there a way to set up a wooksheet so that when a
numeric value is entered into a cell it will format a
selected color to that cell?? Sounds wierd but i have a
usefull idea in mind.
Thanks in advance.
Mark

 

[Peo Sjoblom]

Select the cell, do format>conditional formatting
formula is and put

=ISNUMBER(A1)

click format button and select pattern
click OK twice

I am assuming A1 is the cell in question

 

[JMay]

Example -- select cell C3
click on Format, Conditional Formatting
change Cell Value is to Formula is
and in the box enter
=ISNUMBER(C3)
Select a pattern (color)
OK out

HTH