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.

 

 

 

 

Set Conditions - Formula

  

5. Click the Format button.
6. Select the formatting options, click OK
7. Click OK

Check Anothr Cell
   
  1. Conditional Formatting -- Introduction
  2. Conditional Formatting -- Multiple Cells
  3. Conditional Formatting -- Examples
  4. Conditional Formatting -- Documentation
  
   
  Home Excel Tips Sample Spreadsheets

 

 

 

Contextures contact information

Last updated: May 9, 2008 10:11 PM