Forum Discussion
Solved
Change format at a particular date and time
Hi I have a spreadsheet that I want to highlight cells containing today and before at a particular time of day (7PM ) not midnight. Is this possible? Thanks David
Hello PacificGull08,
Yes, this is possible using Conditional Formatting.
Use this formula (assuming the date/time is in A1):
=A1 <= TODAY() + TIME(19,0,0)Steps:
- Select the range
- Go to Home > Conditional Formatting > New Rule
- Choose "Use a formula to determine which cells to format"
- Enter the formula
- Choose a format and click OK
This highlights any date/time that is today or earlier than 7:00 PM, instead of midnight.
Use conditional formatting to highlight information in Excel
Hi
To clarify things could you post a picture showing a few rows/column where your date/datetime values are & manually highlight those you expect to auto-highlight? Thanks