How to highlight the entire row with conditional formatting
Conditional formatting in Zoho Sheet allows you to highlight the entire row either using formulas or without formulas.
To highlight the entire row with a formula:
- Navigate to Format > Conditional Formatting > Classic > Formula.
- Enter the desired formula and click Apply.
To highlight the entire row without a formula:
- Navigate to Format > Conditional Formatting > Classic > More Rules.
- Select the appropriate rule type and enter the value.
- Check the Apply to row option and select the column.
- Click Apply.
