Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
More than 3 cell highlite colors ?
I have values created by a formula from info pasted into other cells
in X17 to X24, Y17 to Y24. Again in AC17 to AC24, AD17 to AD24. These IF formulas use ="","", to present a blank cell if no data is available. In G29 to G36 I use =X17 to X24 and I29 is =Y17 etc,to move this result to a report cover page. I use CF to change the cell background color in G29 to G36 and I29 to I36 depending on what values appear there, as G29 = 95%, green I29 = A, green, etc. It works great, but.... Now I need a fourth color. Add in's are forbidden. I have VB that will change cell color in G29 to G36, etc, but only when values are typed directly in these cells. It will not update G29 when the value in X17 changes. Is there a way to modify it so that it will copy the value in X17 to G29, etc, and highlite the cell to a specified color per value ? Using Office 2000. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
worksheet set to highlite a cell while data is being entered | Excel Discussion (Misc queries) | |||
why does more than one cell highlite when one cell is selected | Excel Discussion (Misc queries) | |||
Highlite the cell if above 5:31 | Excel Worksheet Functions | |||
Can't format font colors or cell fill-in colors | Excel Discussion (Misc queries) | |||
how do I highlite text within a cell (specific characters) | Excel Discussion (Misc queries) |