Highlight cells with conditional formatting
Colour cells automatically by their value, with colour scales, data bars or your own formula.
- Select the cells.
- On the Home tab, choose Conditional formatting.
- Pick a rule:
- cell value (greater than, between, equal to…),
- top or bottom values, above or below average,
- duplicate or unique values,
- colour scales, data bars or icon sets,
- a custom formula.
- Choose the format and confirm.
Manage, edit or delete rules from the same menu.
Was this article helpful?
Related articles
Still need help?
Write to the Woosool team. Sign in with your Woosool Account and we reply by e-mail and in My requests.