Step 1: On the Home tab select Conditional Formatting, and click Manage Rules.
Step 2: In the Conditional Formatting Rules Manager, select Show formatting rules for: This worksheet,click on the fourth rule Red Text with Strikethrough, and click Edit Rule.
Step 3:Change the formula to=$E5<"7:00:00"and click OK
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit