Numbers above/below a given number being shown in colors
Posted by Melba Brandon on July 31, 2001 2:30 PM
Is there a way in a spreadsheet to make numbers appear in differenct colors based upon their values? Say for example - numbers greater than 70 be colored red and numbers less than 70 being colored green?
Posted by Mark W. on July 31, 2001 2:35 PM
Sure. Use this custom number format...
[Red][>70]General;[Green][<70]General;General
Note: You can substitute any valid number format
(e.g., 0.00) for "General"
