A simple question hopefully.
I have two date columns with date which I want to conditionally format base on the following;
if Cell A3-A2<14 then format the background orange
if Cell A3-A2 is negative then format the background red
I am running Excel 2010.
Now I would like this to be relative to each row in in the column? (i.e. A3-A2. B3-B2. etc)