Results 1 to 2 of 2
2003-04-24, 14:47 #1
- Join Date
- Apr 2001
- Thanked 0 Times in 0 Posts
Color condition on values in cells? (Excel 2000 SP-3)
I am working with an inventory spreadsheet. We have certain items that, if we get down to only 2 of them, we need to be signaled to order more. I would like to figure out some way to color code them so that if the value is equal to or less than 2, the font color of the value turns red instead of black. I can't remember if there is a way to do that automatically in Excel, or if I will have to create a macro of some sort. Any suggestions? Thanks in advance.
2003-04-24, 14:54 #2
- Join Date
- Mar 2002
- Thanked 30 Times in 30 Posts
Re: Color condition on values in cells? (Excel 2000 SP-3)
You can use conditional formatting for this.
Select the cell or cells you want to modify.
Select Format | Conditional Formatting...
Leave the first dropdown box as is ("Value is"), and in the second dropdown box, select "less than or equal to". Type 2 in the box to the right.
Then click the Format... button, and select the red font color, and other options if you wish. Click OK to return to the Conditional Formatting dialog.
Click OK to close this dialog. That's it.