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 can't quite figure out the formula to be able to highlight a cell that also includes text (times) as part of the cell as well. We have cells from yesterday and backwards highlighted red, and cells with today's date highlighted yellow. But when we add a time, it won't show up when we just use the date conditional formatting options like 'Last 7 Days', 'Yesterday' or 'Today.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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.
Thanks. If you change
2PM
31/10/2024
to
31/10/2024 14:00
and
NOON
1/11/24
to
01/11/2024 12:00
the values should be recognized as real date/time values, and conditional formatting should work.
Sorry not sure why the picture wasn't included in the initial post!
What do the cell values look like? If a cell contains a valid date+time value, the conditional formatting rules should work.