|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Highlight Blank Cell Based on Multiple Conditions from Other Cells in Row
Hi all,
I am trying to highlight a blank cell as a reminder to the user to perform an action with an approaching due date (based on multiple conditions). My active cell (the potentially blank cell) is G5. I need the formula to only highlight G5 red if all of the following are true:
I was trying to piece together various rules I had seen from other threads. I'm currently working with what is shown below, but of course it's not working. Any ideas? Thank you in advance for any assistance you can provide. =AND($B$5="C",$D$5="",D5<=(TODAY()-320)) |
#2
|
||||
|
||||
Should the middle argument reference G5 per your explanation of the issue?
=AND($B$5="C",$D$5="",D5<=(TODAY()-320)) |
#3
|
|||
|
|||
Thank you both for the replies. Yes that was a typo in my post (but not in my actual formula). It looks like the issue is with the date.
EDIT Okay I have tried a few iterations and I'm still stuck on the date. I suppose I'm just not understanding. I feel like this should work, but I'm getting buggy results: =AND($B$5="C",D5<=(TODAY()-320),$G$5="") After entering that conditional formula, I tested it by changing the date in cell D5 to some dates that were clearly out of range on both sides. At first it seemed to recognize the cutoff by highlighting red at the right value, but then when I changed the date to the other side of the range, the red would not go away. Any ideas? (I tried putting the arguments in alphabetical order out of curiosity, but that did not seem to make a difference). |
#4
|
|||
|
|||
Actually that is working--I had to save the document for it to stop being buggy. Not sure why but glad it worked.
|
Tags |
conditional formatining, dates, multiple conditions |
|
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 |