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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
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
 
Back
Top