•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
how do i make it so the bar turns red the moment it passes 50% but not turn red for 100%?
Our take
If you're looking to change the color of a bar in your spreadsheet so that it turns red when it exceeds 50% but remains a different color at 100%, you might find the built-in options limited. While the bar settings may not directly offer this functionality, you can explore the "More Rules" section under data rules for custom options. Alternatively, consider manually adjusting the bar colors to achieve the desired effect.
i coudnt find this option inside the bar settings, all i saw is the colors and other unrelevent options to what i want, i tried playing around the 'more rules' in the data rules, but coudnt find anything, is there at least a way to do it manual, like by changing the color of one of the bars without changing the rest?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- How do you vary colors of bar graph by day of the week?I feel really stupid for this because I am searching all over and not seeing answers for this. Like is this a basic option I am missing that is so obvious nobody asks it? Basically I have a bar graph for data points throughout the year, I want something like Mondays red, tuesdays blue, wednesdays green, etc etc The option to "vary colors by point" seems to alternate every 14 or so colors and there doesn't seem to be a way to change the interval, that I can tell. Obviously I can manually change colors but this is excel and there has gotta be a way to alternate that rather than do it for each individual point. Especially since I have multiple "yearly" charts I'd like to do this for. submitted by /u/machinelock [link] [comments]
- 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]
Tagged with
#Excel alternatives for data analysis#generative AI for data analysis#rows.com#big data management in spreadsheets#conversational data analysis#Excel compatibility#real-time data collaboration#intelligent data visualization#data visualization tools#enterprise data management#big data performance#Excel alternatives#data analysis tools#data cleaning solutions#natural language processing for spreadsheets#bar#turns red#50%#100%#data rules