1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Conditional formatting with checkboxes and dates

I need to highlight a cell (Column "I") that has a checkbox if it is unchecked and a date in a separate column (Column "D") occurs in the next 3 days.

https://preview.redd.it/vrpvkbcaxwzg1.png?width=464&format=png&auto=webp&s=40bcf88095d42cc9a11c8edd7ae76375e7a703ed

Thank you

submitted by /u/_Rocksol
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#financial modeling with spreadsheets
#conditional formatting
#checkboxes
#dates
#highlight cell
#Column I
#Column D
#unchecked
#next 3 days
#Excel
#cell formatting
#data validation
#spreadsheet
#user input
#graphic representation
#conditional rules