| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need to change the BG color of a cell dynamically
I have a spread sheet that has monthly totals, projected and actual, I
need the actual amount totals bg color to change to red or green depending upon if the actual was over the projected or under, I also need it to change to blue if the totals are equal. Example: June projected total was 300, actual total was 400, I need to have the BG of the actual change to green because it was over 300. What would I use to accomplish this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
| change cell link in combox box dynamically | Excel Discussion (Misc queries) | |||
| Change a cell's fill color dynamically? | Excel Discussion (Misc queries) | |||
| change operating cells dynamically according to the value of a fixed cell | Excel Worksheet Functions | |||
| Dynamically change column color in chart | Excel Programming | |||
Threaded Mode
