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?
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to change cell background color as part of the If statement?
Say the allowable cost is in A1 and the actual cost is in B1.
Click on B1 and: Format Conditional Formatting... Formula Is =B1A1 then pick the red background (but not too dark) -- Gary''s Student - gsnu200904 "Jim H" wrote: 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. |
#3
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) |