Hello All
I am using Excel 2007 and require help please
I have data in Columns A to T
In column D I have a date Format dd-mm-yyyy
In Column K I also have a date as the same format.
I would like to set a condition format on each row saying the following
D2 - K2
If the answer is = or less than 2 days difference then highlite the whole row Red
This should be easy but I must admit I have a mental block on how to do this so any help would be great please
I am using Excel 2007 and require help please
I have data in Columns A to T
In column D I have a date Format dd-mm-yyyy
In Column K I also have a date as the same format.
I would like to set a condition format on each row saying the following
D2 - K2
If the answer is = or less than 2 days difference then highlite the whole row Red
This should be easy but I must admit I have a mental block on how to do this so any help would be great please