![]() |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#2
|
||||
|
||||
|
Should the middle argument reference G5 per your explanation of the issue?
=AND($B$5="C",$D$5="",D5<=(TODAY()-320)) |
| Tags |
| conditional formatining, dates, multiple conditions |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Formula to make sum based on multiple conditions, HELP! | ilsel | Excel | 3 | 11-15-2017 02:03 AM |
| Merging 2 different cells containing IF formula & change in cell values based on multiple time frame | jay_excel | Excel | 0 | 07-29-2017 11:04 PM |
| Perform calc in active cell then highlight based on formula result | grexcelman | Excel Programming | 4 | 01-12-2015 11:00 AM |
multiple conditions, and blank cells with the countifs function
|
jaden0605 | Excel | 1 | 03-30-2014 01:50 AM |
How to highlight the row based on cell value?
|
Learner7 | Excel | 1 | 12-11-2011 02:28 AM |