![]()
Home Excel Tips Sample Spreadsheets
Excel -- Conditional Formatting -- Based on another cell
download a zipped sample file
Apply 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.
To apply conditional formatting to the cells:
1. Select the cells to be formatted (A2:D4 in this example)
2. Choose Format>Conditional Formatting...
3. 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, 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. Otherwise, the formula will be adjusted in each column, and won't work properly.
5. Click the Format button.
6. Select the formatting options, click OK
7. Click OK
- Conditional Formatting -- Introduction
- Conditional Formatting -- Multiple Cells
- Conditional Formatting -- Examples
- Conditional Formatting -- Documentation
Home Excel Tips Sample Spreadsheets
Contextures contact information
Last updated: May 9, 2008 10:11 PM