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

how to highlight a cell if it equals 09/03/2026

I'm new to excel coding and basically, I have an excel sheet where I have a cell with a task. I want this cell, let's say A1, to turn red, via conditional formatting, on 09/03/2026, so next monday. I don't want to add the date "09/03/2026" somewhere else in the spreadsheet and then compare it with A1, I want to compare TODAY() with the date 09/03/2026. I have tried ISEQUAL(TODAY(), DATEVALUE(09/03/2026)) applied to A1, but it does not work. Any help please? ❤️

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

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel compatibility
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#Excel alternatives
#rows.com
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#AI-powered spreadsheet
#spreadsheet API integration
#Excel
#conditional formatting
#09/03/2026
#highlight a cell
how to highlight a cell if it equals 09/03/2026