Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
How to change MS Excel cell color for a certain value?
I'm entering a set of test scores into Excel in percentage format. How do I get it to change the cell red if the score is less than 70% when I enter that number? I'm using Excel 2007.
2 Answers
- Greg GLv 79 years agoFavorite Answer
First, select all the cells you want to shade red when the score is below 70%, then:
From the Home Tab, click on Conditional Formatting, then select Highlight Cells Rules, Less Than
and enter .7 (or you can enter 70%)
Select your formatting and you're done.
- ?Lv 45 years ago
There is an worried method, and an effortless way. Why no longer are trying the effortless manner first? That's to use the in finding operate. Go to Edit/to find on the Command Menu (or the shortcut Ctrl-F), then form within the value that you are looking for and hit Enter.
