I had some help with conditional formatting but i still seem to have an error that i hadn’t been aware of.
Please see attached sheet which shows the error.
Also can someone explain what the original formatting formatting actually refers to......and any changes required to make it work 100%
Looking at the format you used can i just make sure i understand what it means please:
I take it =AND means that all the terms in the bracket are checked so:
H5="" If H5 is blank AND ALSO
G5>TODAY() the date in cell G5 is bigger than today’s date AND ALSO
G5>0 the date in G5 is bigger than 0.....not quite sure why this one is included?
THEN Format the cell as shown.
So i think that’s all ok but i am not sure about the G5>0 bit
The other thing i don’t understand is that if i look at the formatting of say cell G20, it still uses