Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CF or VBA
In a sheet with (max)10000 rows, any of the rows could be shaded green(when
criteria 1 is met), orange (criteria 2), or red (3). The criteria will appear in column "AB" by formula e.g. =IF($S410,"W",""). This formula will change as I add bits to it but the premise is that the code needs to look at column AB and deal with whatever result is displayed by the formula (max of 3. If the criteria in any cell in "AB" alters or is removed entirely, the row will need to reflect this. How would I do this by code? -- Traa Dy Liooar Jock |