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
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
maybe I misunderstood but I assumed they needed items that are today AND <7pm
another option for the formula could be:
=(A1>=TODAY()) * (A1<TODAY+TIME(19,0,0))
