Think you need to skip the coloring and look at Data = Validation under the
Data menu. You can restrict cell entry to whole numbers.

--
Regards,
Tom Ogilvy


"scotty" wrote:

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