|
|
#1
04-06-2017, 06:06 PM
|
|||
|
|||
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 
|
|
#4
04-07-2017, 12:51 AM
|
|||
|
|||
|
Then I think you should upload a file showing what you have and not least exactly you want.
I tried to make a file that (I thought) did what you wanted, but apparently not. However you are not so helpful in just stating: I'm not following at all
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Conditional formatting
|
bbutl027 | Excel | 15 | 12-05-2016 08:56 PM |
|
Conditional formatting
|
otuatail | Excel | 11 | 07-11-2016 11:30 PM |
| Need flexible lookup for conditional formatting. | bobsone1 | Excel | 0 | 09-06-2014 05:45 AM |
|
Conditional formatting that ignores other formatting rules
|
info_guy2 | Excel | 1 | 07-03-2014 10:07 AM |
| Conditional Formatting | jdc15371 | Excel | 2 | 06-26-2014 06:34 AM |
Windows Vista 
Office 2013
Linear Mode
