M
matt machin
I am using Excel 2002 (but transferring files between 2003 and 2002). I have
conditional formatting set up using "formula is" to compare two values (B2,
D2) and then shade a third cell (A2) green, red, amber according to whether
the first value is the same or larger than (B2>=D2),much smaller (B2<D2-1),
or close to (B2>=D2-1). I've used the format painter to paint to the whole
worksheet (removing absolute cell references first). This works most of the
time, but sometimes when comparing two blank cells it returns green. There
doesn't seem to be any rhyme or reason to it. Also when column B is compared
with D and there is a blank in B but value in D, it returns green (sometimes!)
conditional formatting set up using "formula is" to compare two values (B2,
D2) and then shade a third cell (A2) green, red, amber according to whether
the first value is the same or larger than (B2>=D2),much smaller (B2<D2-1),
or close to (B2>=D2-1). I've used the format painter to paint to the whole
worksheet (removing absolute cell references first). This works most of the
time, but sometimes when comparing two blank cells it returns green. There
doesn't seem to be any rhyme or reason to it. Also when column B is compared
with D and there is a blank in B but value in D, it returns green (sometimes!)