If you change the font colour to match the pattern colour, then the digits
will seem to disappear. This seem to be what you want.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Sandy Mann" wrote in message
...
Look at Format Conditional Formatting. That will do what you want

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Arla" wrote in message
...
I am trying to make the value of a cell a color, instead of the value
input
into the cell. For example, when I enter a 1, I want it to change to
red, 2
to change to yellow, 3 to blue, etc. This would only apply to a certain
range of cells.