MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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"