View Single Post
 
Old 04-06-2017, 06:06 PM
Lmslms80 Lmslms80 is offline Windows Vista Office 2013
Novice
 
Join Date: Apr 2017
Posts: 2
Lmslms80 is on a distinguished road
Default V Lookup with IF for conditional formatting

Hello I'm new here and have progressed quite a bit with excel but can't seem to figure this out.

I have sheet A and B. I would like to see if some names from A are on B. If on B then highlight the name on Sheet A if date 1, date 2 or date 3 that are on sheet B are less than TODAY(). So if anyone of the dates are less than TODAY () then I want to highlight the name in sheet A. Please help. Thanks
Reply With Quote