| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Color change
I would like the color to change in a cell if the result is greater than
another cell. What I have is a cell(D21) that has added up a column of estimated dollar figures (=Sum(D5:D20)). I than have a cell(E21) that add up a second column of actual figures (=SUM(E5:E20)). what I want to do is to have cell E21 value to show up in red if it is greater that cell D21. -- John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can I conditionally change font color, or background color? | Excel Worksheet Functions | |||
| change background row color with change of date in a cell | Excel Discussion (Misc queries) | |||
| How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) | |||
| Change of text or background color doesn't change on the screen. | Excel Discussion (Misc queries) | |||
| Allow users to change the color of the comment indicator color so. | Excel Discussion (Misc queries) | |||
Threaded Mode
