How can I replace a Value in a cell with a color?

A

Arla

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.
 
S

Sandy Mann

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
B

Bernard Liengme

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
 
Top