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, 2022 in Others by Kithuzzz
• 38,010 points
885 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, 2022 by narikkadan
• 63,700 points

Related Questions In Others

0 votes
1 answer

How to trick an Excel function that wants a column as input to accept a list of values as if these were in a column

Use VSTACK: vstack to make an array: Use it as value ...READ MORE

answered Mar 18, 2023 in Others by narikkadan
• 63,700 points
329 views
0 votes
1 answer

How to automatically get a specified range of data from Excel to XML in VBA

Range method works, always identify the sheet ...READ MORE

answered Mar 18, 2023 in Others by narikkadan
• 63,700 points
615 views
0 votes
1 answer

How to automatically assign a color to the maximum and minimum values in a set of selected cells in Excel?

See Conditional Formatting, which may be accessed ...READ MORE

answered Apr 7, 2023 in Others by Kithuzzz
• 38,010 points
371 views
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,190 points
1,289 views
0 votes
1 answer

Excel - Conditional Formatting not working because cell has an existing formula

Go to Conditional Formatting -> Rules to ...READ MORE

answered Dec 10, 2022 in Others by narikkadan
• 63,700 points
3,980 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, 2022 in Others by narikkadan
• 63,700 points
712 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, 2022 in Others by narikkadan
• 63,700 points
1,015 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, 2022 in Others by narikkadan
• 63,700 points
1,535 views
0 votes
1 answer

How to programmatically get the values of a spilled Excel range in VBA?

By using the Text property, I was ...READ MORE

answered Mar 23, 2023 in Others by narikkadan
• 63,700 points
808 views
0 votes
1 answer

How to increment the Range of a For Each loop - Excel VBA

Your formula seems to sum 1 single ...READ MORE

answered Jan 7, 2023 in Others by narikkadan
• 63,700 points
2,280 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