Hi I'm trying to figure this out, but haven't had much luck.
Column A = Due Date
Column B = Status of task (Complete, Active, Pending)
So what I'm trying to do is highlight the "Pending" cells in column B if the date in column A is over 30 days ago.
What I had
=IF(B2="Pending",...
but I can't finish it.
So I want a formula that says If B2=Pending & A2=date over a month ago, then highlight B2 bright red.
Any help would be greatly appreciated. Thank you!
- Santana
Last edited by PowerSchoolDude; 10-15-2009 at 05:56 PM. Reason: Bad spelling in title
Try
=(B2="Pending")*(A2<TODAY()-30)
You're awesome!
It works perfect. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks