| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get cell to change background color automaticly (4color)
I need to have a cell in my worksheet that changes color
from a date clear background, then yellow,then green, then red and finally grey. I have tried conditionnal formating but limited to 3 colors yellow green red but can't get grey automatic. Can someone help? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I get cell to change background color automaticly (4color)
If you are using Excel 2003 or earlier, then you are limited to 3
conditions ... .... unless you download Bob Phillip's CFPlus add-in, which will give you many more - it's available he http://www.xldynamic.com/source/xld.....Download.html Hope this helps. Pete On Oct 26, 8:27 pm, Mario wrote: I need to have a cell in my worksheet that changes color from a date clear background, then yellow,then green, then red and finally grey. I have tried conditionnal formating but limited to 3 colors yellow green red but can't get grey automatic. Can someone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change Cell background color by selection | Excel Worksheet Functions | |||
| change background row color with change of date in a cell | Excel Discussion (Misc queries) | |||
| how do I change cell background color only when cursor is over it | 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) | |||
Linear Mode
