| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filling a Cell with Yellow backgound after testing for -ve cell d
In my worksheet "Major MACD Sep'09" I have calculated positive or negative
price variance data (format +/- $$.cc) from Row 5 down in each alternate Column from C through BI (ie Column C,E,G,I etc to BI). After the latest entry in any Column there is always the value 0.00. I need to find any criteria where the last three price variation entries before the 0.00 value are all negative and if this test is met I need to fill Row 3 of that particular Column with a yellow background in order to highlight the situation. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy cell backgound color to another cell | Excel Programming | |||
| Yellow pop-up message in cell | Excel Discussion (Misc queries) | |||
| formula for if Cell c1 is yellow shaded cell d1 should be yellow | Excel Discussion (Misc queries) | |||
| IF the cell is yellow... | Excel Discussion (Misc queries) | |||
| Value of a cell in a range if color is yellow | Excel Programming | |||
Threaded Mode
