How to add Conditional Formatting in Excel for a Range of Values

0 votes

My Excel spreadsheet is formatted to look like a report card. Percentages are used to indicate the values. I want to use three different colours to highlight all numbers between 0 and 49, 50 and 99, and 100. When I make a new rule, it's difficult for me to apply these three separate conditions in the range. If that makes sense, it continues presuming that I want to evaluate the numbers relative to one another rather than just the value in the cell. We appreciate any assistance!

Current Results

Oct 24 in Others by Kithuzzz
• 20,660 points
31 views

1 answer to this question.

0 votes

Three distinct rules are required, one for each circumstance. Choose the range, then use a formula to generate new rules. The formulas I used in this example are visible. Keep in mind that the formula must utilize the first cell in the selection as a reference and should not contain any $ signs, so use C2 rather than $c$2. C2 is the initial cell in the selection in my example, and my rules are:

=C2<0.5
=C2<1
=C2=1

Take a look at the screenshot to see how the rules must be set up such that cells with less than 50% of the yellow colour are not affected. For added assurance that no additional rules are enforced, you might optionally check the "Stop if true" box.

enter image description here

answered Oct 24 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

How to apply zoom animation for each element of a list in angular?

Hey @Sid, do check if this link ...READ MORE

answered Jul 30, 2019 in Others by Vardhan
• 13,200 points
608 views
0 votes
1 answer

How to get rid of a #value error in Excel?

Changing the format to "Number" doesn't actually ...READ MORE

answered Oct 3 in Others by narikkadan
• 37,660 points
73 views
0 votes
1 answer

How to stick an embedded document in a specific cell of an excel

Solution Select the documents (you can use the ...READ MORE

answered Oct 18 in Others by narikkadan
• 37,660 points
29 views
0 votes
1 answer

How can I use a command button in excel to set the value of multiple cells in one click?

Try this: Private Scan As Integer Private Sub CommandButton1_Click() ...READ MORE

answered Oct 24 in Others by narikkadan
• 37,660 points
57 views
0 votes
1 answer

Excel automatically converting 7 digit CAS number to another number (date?)

Looks like you could use: The formula in D2: =SUBSTITUTE(F ...READ MORE

answered Sep 25 in Others by narikkadan
• 37,660 points
57 views
0 votes
1 answer

Thousand and million formatting for negative numbers (excel/ googlesheets)

Its not possible. What you could do is ...READ MORE

answered Sep 25 in Others by narikkadan
• 37,660 points
56 views
0 votes
1 answer

Excel Conditional Formatting based on Adjacent Cell Value

The row number used in the formula ...READ MORE

answered Oct 10 in Others by narikkadan
• 37,660 points
152 views
0 votes
1 answer

Excel Issue- custom format for Turkish currency

What about: #.##0,00 [$₺-tr-TR] Where #.##0,00 € would do for ...READ MORE

answered Oct 10 in Others by narikkadan
• 37,660 points
106 views
0 votes
1 answer
0 votes
1 answer

How to create a drop-down in excel with custom values

You can accomplish that using code rather ...READ MORE

answered Sep 25 in Others by narikkadan
• 37,660 points
56 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP