Wooksheet setup

M

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
 
P

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
 
J

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
 
Top