•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Conditional formatting delinquency list
Hello, looking for some advice on how to fix an issue I’m encountering. I believe due to blank cells this becomes a problem as this highlights the cell for delinquencies.
Column “I” is designated to specific individuals. So most of those who I’m tracking will remain blank”
FX used:
=or($D2<Today()+30, $E2<Today()+30, $F2<Today()+30, $G2<Today()+30, $H2<Today()+30, $I2<Today()+30)
I think the possible solution would be an IF fx to ignore blank cells but not sure how write the fx in regards to the blank cell.
Thank you for any help in advanced.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#Excel alternatives
#conditional formatting
#delinquency list
#blank cells
#tracking
#column I
#FX
#IF function
#formula
#highlight
#today
#individuals
#problem solving
#advanced help
#checking dates