Changing cell text color based on cell number
Maybe you want
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"scotty" wrote in message
...
I have one column of 50 rows in which I put input Whole numbers. In cell
A1
I may input 20. When I input that I may want the text color red or I may
want
it to be blue. How can I dictate what color is used with out having to
change the color manually. I was working along the lines of if I enter 20
it
is blue and If I enter 20.1 is red and format the cells so they dislay
zero
decimal points. I have not been able to figure this out. Help is
Appreciated
|