•1 min read•from 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? ❤️
[link] [comments]
Want to read more?
Check out the full article on the original site