I want to be able to cause a cell B3 to turn red if it is a later date than B2. I also want to be able to turn cell B4 red if it is more than 10 working days later than cell B2.
Is there a way of doing this?
Your help really appreciated!
in the conditional formatting for B3 you can use "Formula Is" and enter =B3>B2 and in b4 you could do the same but =B4>B2+10
Microsoft Office Discussion