Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 11-21-2019, 12:15 PM
PrincessApril PrincessApril is offline Highlight Blank Cell Based on Multiple Conditions from Other Cells in Row Windows 10 Highlight Blank Cell Based on Multiple Conditions from Other Cells in Row Office 2019
Competent Performer
Highlight Blank Cell Based on Multiple Conditions from Other Cells in Row
 
Join Date: Nov 2019
Posts: 102
PrincessApril is on a distinguished road
Default

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).
Reply With Quote
 

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
Highlight Blank Cell Based on Multiple Conditions from Other Cells in Row multiple conditions, and blank cells with the countifs function jaden0605 Excel 1 03-30-2014 01:50 AM
Highlight Blank Cell Based on Multiple Conditions from Other Cells in Row How to highlight the row based on cell value? Learner7 Excel 1 12-11-2011 02:28 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:25 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft