I am looking for a CF that will give me the following
1. When the cell A1 is empty I want the cell to have no format relative to the contents of the cell B1 that contains the CF
2. When cell A1 contains a date that is great than the date in cell B1 then A1 should be Red
3. When the date in cell A1 is less than or equal to the date in B1 then A1 should be Green
I did have a very simple CF formula for 2 & 3
For 2: Cell value <= B1 Format Green
For 3: Cell value > B1 Format Red
The problem I have is when A1 is empty with no date, the cell is green due to the CF. If A1 is empty I want the cell I want the cell to have no format.
Hopefully this makes sense. ( Fingers crossed)
Best Regards
Marcie Be
1. When the cell A1 is empty I want the cell to have no format relative to the contents of the cell B1 that contains the CF
2. When cell A1 contains a date that is great than the date in cell B1 then A1 should be Red
3. When the date in cell A1 is less than or equal to the date in B1 then A1 should be Green
I did have a very simple CF formula for 2 & 3
For 2: Cell value <= B1 Format Green
For 3: Cell value > B1 Format Red
The problem I have is when A1 is empty with no date, the cell is green due to the CF. If A1 is empty I want the cell I want the cell to have no format.
Hopefully this makes sense. ( Fingers crossed)
Best Regards
Marcie Be