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.
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.
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 Is4. In the text box, enter a formula that refers to the active cell in the selection.
In this example, the formula is: =$B2>75
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.
3. From the first drop-down list, choose Formula Is4. In the text box, enter a formula that refers to the active cell in the selection.
In this example, the formula is: =$B2>75
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 OK7. Click OK
0 comments:
Post a Comment