•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Setting up Conditional Formatting
Our take
Are you struggling to get conditional formatting to reflect the true performance of your data? It’s a common challenge when working with percentages that can range from 0% to 100%. When you apply a blanket formatting approach, the highest and lowest numbers don’t always reflect their actual value, which can lead to misleading visuals. In this guide, we’ll explore how to set up conditional formatting so that each cell displays color that genuinely represents its value.
I'm having trouble working out how to get conditional formatting to work for what I need. So basically I will have 4 separate numbers (shown as a percentile) that could range from 0% - 100%. Now i want each number to change colour based on where it is in regards to 0-100. Now if i select all 4 cells and format them to have red for 0% and green for 100% then the highest number is always green. And the lowest number, even if its say 78%, is red. And if i format each cell independently then they always come out green, regardless of the number. So how do I get each cell to play by my rules?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- why does conditional formatting color cells that there values are out of the range?why is numbers between 5% and 10% being coloredd?, i made a role saying numbers above 10% or lower than -10% be red and numbers between -5% and +5% are green, no rules for 5%-10%, why are they getting colored? https://preview.redd.it/if564q382fog1.png?width=915&format=png&auto=webp&s=ff82020d18166e3e1df8fbdcded4d795fd0917a1 https://preview.redd.it/5xlnnr382fog1.png?width=689&format=png&auto=webp&s=f0b4517c94548b4f30c46da682e2c89a51cacca3 https://preview.redd.it/oy95js382fog1.png?width=792&format=png&auto=webp&s=ab32e98b28ff6c41f34a76d0d92e6af1d695f0f1 submitted by /u/Difficult_Warning126 [link] [comments]
- Conditional Formatting with another cell?Hi everyone! I'm trying to create a condition where depending on the value of two cells, it will change the fill of one of them. For example, If Cell A is < 10% AND Cell B is X, then Cell A will be green. If it is > 10% and Cell B is X, then Cell A is red. How would I go about doing this? submitted by /u/Educational-Bass-413 [link] [comments]
- Conditional formatting in a single cell based on which interval it is inHi all I have a sheet where we log our machine hours (how many hours a specific machine has run for) I want to create a conditional formatting based on whether the machine has run 0-200 hours(green), 200-350 hours (yellow) or 350-500 hours (red) Hours will continually go up, so I'm either looking for a formula/formatting to recognise these intervals (eg 7250 = yellow, but also 8250=yellow), or only the fixed intervals but with a way to "reset" the counter after a service has been done to the machine. Hope this makes some sort of sense! submitted by /u/Askebon [link] [comments]
- Negatives in Red in a "Format as Table"I have a document that I have used "Format as Table" so each row is a different color. I want to make it so that when a number is negative, it turns red. I thought I was able to do that with conditional formatting, but I just now realized it makes the background of all the cells white, even those in the row that is colored. Any way to fix this? I already tried formatting the cells using the number format "0.00%;[Red]-0.00%", but still having the same issue. Any ideas on how to get this to work the way I want it to? I really want don't want to have to manually format as a table (different color every other row). Pic to help show what the issue is. https://preview.redd.it/wje9ghguo7zg1.png?width=1928&format=png&auto=webp&s=3f6510812414388e511f564aa676d4744152272e submitted by /u/Significant_Floor_54 [link] [comments]
Tagged with
#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#rows.com#Excel compatibility#cloud-based spreadsheet applications#conditional formatting#percentile#numbers#colour#0%#100%#highest number#lowest number#formatting rules#cells#changing colour#red#green#cell formatting