Have you ever had a need to use conditional formatting in a row in your worksheet? Suppose you need to highlight all the values in your row that exceed a certain number.
I had a client call me regarding this issue not too long ago.
Follow the steps below to learn how to accomplish this task:
- If your data is contained in cells B11:D30, for instance, select cell B11.
- With B11 still selected, scroll so that you can see cell D30. The entire range should now be selected and B11 should still be the active cell.
- Be certain the Home tab of your Ribbon is displayed.
- Click the conditional Formatting too and Excel will display a series of choices for you.
- Click New Rule to display the dialog box.
- In the Select a Rule Type area select Use a Formula to Determine Which Cells to Format.
- In the formula space enter the formula below:
- Click the Format button. Excel will display the Format Cells dialog box.You can now specify how you want the cells that are greater than 25,000 to be displayed.
- Click OK to close the dialog box.
- Click OK to accept your conditional formatting.
The formula works because you use the absolute indicator (the $ sign) just before the column letter. Any reference that is preceded by the $ sign is not changed when Excel propagates it throughout a range.
Versions 2007, 2010
1 thought on “Using Conditional Formatting in MS Excel”
I can’t get this to work and I can’t understand why the formula starts with =$E3
Comments are closed.