Aug 31 2023 06:04 PM
Sep 01 2023 03:28 AM
Assuming that you want to start in row 2, select the entire rows 2 to 1000, or however far down you want.
The active cell in the selection should be A2.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
Activate the Fill tab.
Select a highlight color.
Click OK, then click OK again.