Colour cells by their value

Conditional formatting colours cells by rules, like everything above 1,000, or every Open order.

2 steps2 minutesPlans: Free, Personal, Pro, Enterprise

  1. 1

    Select the cells

    For example the revenue column.

    Select the cells
  2. 2

    Press Conditional Formatting

    On the Home tab. Pick a rule, bars or colour scales.

    Press Conditional Formatting

Was this helpful?

We count yes and no per article. Nothing about you is stored.

Still stuck? Ask us.

People, not a bot. We answer within one working day.