Conditional Formatting

[D Willett]

Hi.

The following Conditional Formatting formula's:

=D4=TODAY()

=D4<TODAY()

=AND(D4-TODAY()>=0,D4-TODAY()<=30)

Can I ask for assistance on these? I need the expressions to ignore empty cells?

TIA

[StuartR]

How about

Code: Select all

=AND(D4<>"",D4<TODAY())

[D Willett]

Perfect StuartR Thank You...