Hi everyone

i am trying to use conditional formating to change the colour of a cell. Overally this is fairly simple but i am trying to apply 2 conditions to the cell, one instance it will turn yellow, another it will turn red.

I am using calendar dates so form example:

First condition

If date in cell A1 is bigger than date in cell A2, fill the cell yellow.

Second Condition

If date in cell A2 is also bigger than date in cell A3, fill the cell red.


Any ideas?