Highlight the whole row with $

Premium

You selected A2:C20 and want to highlight the whole row when sales are over 10,000. In D2, write the rule so every cell in the row tests column C. Lock the column with $, but not the row.

D2
ABCDEF
1Rep Region Sales Rule
2Lars North 12500
3
4
5
6
7
8

Premium lesson

Unlock Conditional formatting and every other lesson

This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.

Next with premium:Drop-down lists and data validationCOUNTIF

Your first month for $9.50 $19

50% off your first month when you join today.

Get your first month for $9.50

Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.

Already premium? Sign in
Need help?