|
Download a zipped sample file for this
Excel tutorial
Video: To view the steps in a short
video, click here
Apply Excel Conditional Formatting to a Row
You can apply conditional formatting that checks the value in one cell,
and applies formatting to other cells, based on that value. For example,
you could colour the entire row in a table, if the values in column
B are over a set value.
In this example, we'll colour cells blue, if the number of units, in
column B, is greater than 75. At a glance, we'll be able to see which
dates have a high number of units.
To apply conditional formatting to the cells:
1. Select the cells that you want to format (A2:D4 in this example)
2. In the menu bar, choose Format > Conditional Formatting...
3. In the Conditional Formatting dialog box, from the first drop-down
list, choose Formula Is
4. In the text box, enter a formula that refers to the active cell in
the selection. In this example, we selected A2:D4, and cell A2 is the
active cell. So, in the formula, we'll refer to cell B2, because it's
in the active row.
In this example, the
formula is: =$B2>75
In this example, we use an absolute reference to column B ($B),
to ensure that the conditional formatting in all columns refers to the
value in column B.
If we simply use a relative reference (B), the formula will
be adjusted in each column, and won't work properly. Each cell will
refer to the cell to its right, instead of refering to the cell in column
B.
|
|
|
