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

Conditional formatting with checkboxes and dates

Our take

To enhance your spreadsheet's functionality, you can use conditional formatting to highlight cells in Column "I" that contain unchecked checkboxes, provided a corresponding date in Column "D" falls within the next three days. This dynamic visual cue not only simplifies task management but also ensures you stay on top of important deadlines. By implementing this straightforward method, you can effectively monitor your tasks and enhance your productivity. Explore how this innovative approach can transform your workflow and keep you organized.

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]

Read on the original site

Open the publisher's page for the full experience

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