Conditional Formats - between values within a formula?

  • Thread starter Thread starter watfordone
  • Start date Start date
W

watfordone

I am trying to write a formula within conditional formats that says:

If The Order Date (D6) is between 1day and 5 days from Todays Dat
(TODAY()) highlight orange UNLESS the Order Out To Date (I6) is th
same as Inital Order Amount (C6) (i.e. Order Complete).

Basically I want it to highlight the cell if we've only got 5 days to
day to go before the order needs to be completed BUT not to highligh
if the order is completed.

I'm so bad at formulas, someone please help me.

Many Thanks
 
=AND(D6>=TODAY()+1,D6<=TODAY()+5,I6<>C6)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top