To highlight entire rows or columns in Excel using conditional formatting, you should do the following:
- In the desired sheet, select the range that should be formatted conditionally.
- On the top ribbon, click on the Home tab.
- In the Styles group, click on Conditional Formatting.
- Choose a formatting style from the drop-down menu.
- Choose the formatting criteria from the drop-down menu.
- Click OK and you will see the conditional formatting in effect.