| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Colourcoding range between two values
Hi,
In the range C3:BC277 I have an arrayformula. In each row there will always be one cell with the value 1 and sometimes a cell with the value 2. 2 will always be to the right of 1. The sheet is basically a gantt chart, so I would like to colour the cells with values 1 or 2 - this is easy enough, but colouring the cells between the 1 and the 2 is giving me some trouble. I cannot use xlToRight since all cells contains a formula, so what to do? Any pointers? /Sune |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate values in an unlimited range of cells in a column WITHOUTalso calculating values that had previously been filtered AGAINST? | Excel Discussion (Misc queries) | |||
| SUMPRODUCT or SUMIF if any values in a range equal any values in another range | Excel Worksheet Functions | |||
| Sum values in columns based on values in named range | Excel Worksheet Functions | |||
| Search/Filter to find values in another range based on two cell values | Excel Programming | |||
Threaded Mode
