MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Count Days, check date Conditional


Posted by Squirrel on February 19, 2001 4:43 PM

Thanks for looking to see if you can help! I have 2 diffrent dates in 2 cells (col.), I need to check for 2 things, 1st if my product expires in seven days I need the cell to change to red in both col., 2nd Need cell a1 to look at a2 and turn yellow if a2 has older date, (checking stock rotation).

pickline PullLine
2/23 3/3


Posted by Dave Hawley on February 19, 2001 5:28 PM

Squirrel, select your data in Column A and B starting from cell A1, then go to Format>Conditional Formatting. Select "Formula is" the type: =$A1>=TODAY()-7 then select Format|Patterns and select Red. Click OK then Ok again.

Now select the same range again but only in Column A starting from A1 and then go to Format>Conditional Formatting. Select "Condition 2", "Formula is" the type: =AND($A1>$A2,$A2<>"") then select Format|Patterns and select Yellow. Click OK and OK again.

DaveOzGrid Business Applications