Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Stumped on Formula
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 -- Jessamynhp ------------------------------------------------------------------------ Jessamynhp's Profile: http://www.excelforum.com/member.php...o&userid=28218 View this thread: http://www.excelforum.com/showthread...hreadid=477666 |
#2
|
|||
|
|||
Stumped on Formula
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 On Wed, 19 Oct 2005 15:59:13 -0500, Jessamynhp wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
writing a formula for a colored value | New Users to Excel | |||
Formula works in some cells, doesn't in other | New Users to Excel | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |