Conditional Formatting based on Dates

[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

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

These work fine, but what I am trying to do is have the cell go

yellow if L10 is 5 days away from the value of TODAY()
orange if L10 is 5 days away from the value of TODAY()

Would there be a specific order they would need to go in to make this work correctly

Many thanks

 

[mart37]

place the rules in order
use: stop if true

 

[ExcelRoy]

Hi mart37,

I have tried them in all sorts of order but cant seem to get anything working the way I need

Thanks

 

[mart37]

yellow and orange have the same condition????

=AND(LEN(L10),TODAY()+5=L10)

 

[ExcelRoy]

Hi mart37,

sorry it should be 3 and 5 days

This almost works, it only highlights the 5 days, I need 1-5 days

Is this possible

many thanks by the way

 

[mart37]

>=

 

[ExcelRoy]

Many thanks for your help, much appreciated