Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Conditional formatting date?
I would like to highlight the 4th day of the month in my budget records. I am using Excel 2007. I highlighted my date column A, made a rule ="day(a1)=4" but nothing shows. Any suggestions?
2 Answers
- garbo7441Lv 77 years ago
You could use the DATE function:
=A1=DATE(YEAR(TODAY()), MONTH(TODAY()),4)
Edit: fix Y/A truncation of formula
- expletive_xomLv 77 years ago
your formula is correct
the only issue i see is the quotes
https://www.flickr.com/photos/89525565@N02/1388486...
in case the picture didnt show up
=DAY(A1)=4
