Conditional Formatting =TODAY()

[ExcelRoy]

Hi all,

I am trying to get a status in my data to show different colours for delivery dates that are in L10 down, the status being in P10 down

At the moment I have CF for the following

=TODAY()>L10 = Red
=TODAY()<L10 = Orange
=TODAY()=L10 = Green

For some reason if there is nothing in L10 yet it shows red, is there a way to have no CF if L10 is empty

Many thanks

 

[steve the fish]

Heres one possible:

=AND(LEN(L10),TODAY()>L10)

 

[ExcelRoy]

That's perfect, many thanks

Could I please ask another question

I am trying to make a traffic light system work to let me know how close I am getting to the delivery dates in L10

I would like Yellow if its within 5 days, Orange if its within 3 days

I cant seem to get this to work

Many thanks for your help

 

[steve the fish]

Green when value >= the value:

=TODAY()+6

Amber when value >= the value:

=TODAY()+4

Then red the rest. Play around with that.