Stumped on Formula

  • Thread starter Thread starter Jessamynhp
  • Start date Start date
J

Jessamynhp

I need help trying to come up with a formula for the following....

I need to complete a conditional format to my "order number" column for
all orders that have exceeded five days from original order date (i have
a seperate column for order date)

Please help
 
Order number i column A and order date in column B:
In A2 use the following conditional format and just copy down:
=B2<TODAY()-5

Be aware that Excel might put " " around the formula after you press
OK, just remove them afterwards.

Per Erik
 
You must log in or register to reply here.

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

Add/Subtract columns from tab to tab in same file 3
Abrupt change in formula results using sumproduct 4
Pivot Table Calculations 2
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Add values based on text color with the criteria of a date 7
Lookup returning wrong results 0
use month in cell date to sum all relevant cells 2
looking up cell address 1

Back
Top