J
Jock
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($S4>10,"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?
criteria 1 is met), orange (criteria 2), or red (3).
The criteria will appear in column "AB" by formula e.g. =IF($S4>10,"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?