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.

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.

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.