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

 

[Fluff]

How about

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

 

[etaf]

For 2: Cell value <= B1 Format Green
use a formula
Select A1 and use CF
Formula
=AND ( A1 <> "" , A1 < = B1 )
Format green

 

[Marcie Be]

How about

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

[/QUOTE
Thank you @Fluff

 

[Marcie Be]

For 2: Cell value <= B1 Format Green
use a formula
Select A1 and use CF
Formula
=AND ( A1 <> "" , A1 < = B1 )
Format green

Thank you @etaf

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Marcie Be]

@Fluff This formula gave me the out come I as looking for other than another CF affecting Cell B1 has now been affected.
I also have a CF in Cell B1 Formula:=$C5="Data Transfer" Format Grey. This CF no longer works because of the new CF =AND ( A1 <> "" , A1 < = B1 )
Can you help resolve please?
Best Regards
Marcie Be

 

[Fluff]

What are the ranges those rules are applied to?

 

[lovejanu4u]

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

 

[Marcie Be]

What are the ranges those rules are applied to?

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