Conditional Formatting for a cell when empty and when it contains a date

[Marcie Be]

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

 

[Marcie Be]

Formula
=AND ( A1 <> "" , A1 < = B1 )

@lovejanu4u Thank you

 

[Fluff]

If they are not applied to the same ranges then they should not affect each other.

 

[Marcie Be]

Range
$A1 to $A12
$B1 to $B12

Actually the formula :=$C5="Data Transfer" could be $C1

I have simplified the cell locations to A, B & C. In reality that are part of a much larger worksheet where the locations start at $AG6 & $AK6
I hope this helps

@Fluff does this help?

$AG6 equates to A1
$AK6 equates to B1

 

[Fluff]

See post#12

 

[Marcie Be]

If they are not applied to the same ranges then they should not affect each other.

See post#12

Thank you.
I needed to include an OFFSET Formula which I had missed. Problem solved
Thanks again

 

[Fluff]

Glad you sorted it & thanks for the feedback.