I'm having trouble putting the correct conditional formatting on a column of dates. Any help would be greatly appreciated!!
Basically, in column 'A' I have a list of appointment dates. Column 'B' contains breach dates for a 10week target. And Column 'C' contains breach dates for an 18 week target. Looking something like this:
Appointment ---10wk breach--- 18wk breach
11/06/2009 ---16/02/2009--- 13/04/2009
01/06/2009 ---21/05/2009--- 16/07/2009
09/06/2009 ---05/02/2009--- 02/04/2009
03/06/2009 ---11/05/2009--- 06/07/2009
I need to format column 'A' so that the cells will turn Amber if the appointment was after the 10 wk breach date and turn Red if it was after the 18 wk breach date. I hope that makes sense!
I know I need to use the conditional formatting function, but am not sure of the formulas etc I need to put in!
If someone could help me out that would be fantastic!!![]()
Bookmarks