I have a date in Column H (date 3) that I want to turn either red if it is after the date in column G (date 2) or green if it is on or before. This I can do without a problem. The problem that I have is then pasting that formatting down into other cells and is picks up the original row in column G that I started with! Can anyone help!
Date 1 Date 2 Date 3
09/02/15 13/02/15 14/02/15
** date two is a formula of Date 1 +4days
Bookmarks