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 |
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 |
All times are GMT +1. The time now is 01:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com