Excel -- Conditional Formatting -- Based on another cell download a zipped sample file Video: To view the steps in a short video, click here 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 To view the steps in a short video, click here
Conditional Formatting -- Introduction Conditional Formatting -- Multiple Cells Conditional Formatting -- Examples Conditional Formatting -- Documentation

Home     Excel Tips     Excel Files      Blog    Contact
		The Excel Store	Debra Dalgleish

Last updated: July 5, 2008 10:43 PM