Jump to content

Point to value thresholds in a cell


Recommended Posts

Point to value thresholds in a cell

You can use conditional formatting to alert you to significant changes in cell values. For example, in a worksheet that tracks students' grades, conditional formatting can draw attention to quiz averages that have fallen below a passing grade of 60 percent.

To apply conditional formatting so average values below 60 percent are displayed in red, follow these steps:

1. Select the cells you want to format.

2. Go to Format | Conditional Formatting.

3. Under Condition, choose Cell Value Is.

4. Select Less Than from the first drop-down list, and enter 60% in the text box.

5. Click Format and change the font color to red.

6. Click OK twice.

When you return to the spreadsheet, all averages below 60 percent will be displayed in red. As future grades are entered, the format of the cells with the students' average grade will change accordingly. You can apply other conditional formatting rules by clicking Add in the Conditional Formatting dialog box.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...