| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to change cell background color as part of the If statement?
Try Format Conditional formatting Cell value is Greater than =C1
Format Patterns -select red OK your way out. Assumes you are formatting G1 and C1 is the allowable cost. When G1 exceeds C1 you get a RED G1. HTH Regards, Howard "Jim H" <Jim wrote in message ... I have a spread sheet that I have set up to use for my home budget. In doing this I would much like to visually see when a budgeted item has exceeded the allowable cost by having the background color of that cell to change to the color red if the cost exceeds the set amount. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change Cell background color by selection | Excel Worksheet Functions | |||
| Change background color with IF statement | Excel Worksheet Functions | |||
| change background row color with change of date in a cell | Excel Discussion (Misc queries) | |||
| Cell Background Color Change according to numerical value | Excel Discussion (Misc queries) | |||
| background color of my cell does not change | Excel Discussion (Misc queries) | |||
Hybrid Mode
