This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I'm using a simple formula in conditional formatting to shade rows greater than today =$A2>TODAY()
For the most part it is working as expected. However, I have two rows with today's date (2/1/2020) - the format is applied to one of the rows but not the other.
To troubleshoot I selected a random cell and did =TODAY() to check the date excel is registering as today. The result was correct 2/1/2020
I then did a conditional format for <>TODAY() and the format was applied to all rows except one of the 2/1/2020 rows and a row with 1/31/2020!
Additionally, when I tried changing some of the dates which did not have the formatting to later dates, instead of shading the row I changed, the format was applied to the row above it.
I removed other formatting which had been applied to ensure this was not interfering. I haven't had any luck searching for potential solutions.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Hello Samantha
I am V. Arya, Independent Advisor, to work with you on this issue. I suspect that this contains time also.
See if =INT($A2)<>TODAY() works for you.
If not, I would like to see your workbook which you share through Onedrive.
By combining the solutions provided by HansV and V. Arya this has been resolved.
=INT($A1)>TODAY()