Conditional Formats - between values within a formula?

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
 
B

Bob Phillips

=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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting Conundrum 3
Cobditional Formatting Rows based on dates in action plan. 0
Conditional Formatting 6
Conditional Formatting Less Than Today Week Days only 0
Conditional formatting with dates 7
Conditional Formatting - Cannot get it to work, please help 1
Conditional Formatting 2
Conditional Formatting with Partial name search 2

Top