Stumped on Formula

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
 
P

Per Erik Midtrød

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
 
Top