Skip to content

Lessons in your language are coming soon. Formulas already work in your Excel language.

Lesson 2/5

Lock the limit with $

Exercise 1 of 3

The budget limit is in F2. In D2, write a rule that highlights amounts above the budget. The rule is copied down, so the budget cell must stay fixed.

About this lesson

A rule is copied to every row of its range, and relative references move with it. Put $ in front of the row number when a reference must stay on one cell, such as a budget limit.

In this lesson

  1. The budget limit is in F2. In D2, write a rule that highlights amounts above the budget. The rule is copied down, so the budget cell must stay fixed.
  2. Highlight the invoices that are higher than the first one (INV-101 in row 2). Write the rule in D2.
  3. Someone wrote =C2>F2 to compare amounts with the budget in F2. Why does it highlight the wrong rows?

Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.

fx

Type in D2 and press Enter to check.