I am trying to get a cell to show up as a gradient based on the number it contains. For example. If the number in K31 is less than or equal to 50, I want the cell to be red; 75, yellow; greater than or equal to 100, green. I have been trying to do this for awhile now and cannot get it to work. Please help (:

like
Posting as :
works at
You are currently posting as works at

You just need 3 simple conditional formatting rules. Click new rule and then use "Format only cells that contain" rule 3 times. First rule will be to fill cell with red for values between 0 and 50, then a second rule for yellow for values between 51 and 75 and the final one for green for values between 75 and 100.

likehelpful

Thank you!!! This is exactly what I was looking for (:

Conditional formatting

like
Post Photo

Looks like what you’re doing is setting a % gradient. I’d let that go and just do a color fill conditional format.

like

Update: because I was using percents - the conditional formats had to be .##, not just ##. That was the major issue I was facing

Related Posts

What are all the product based companies available in Chennai location. If you know please comment.

like

Looking for recommendations of any good non-finance books to pass some of the downtime at home

like

Not a very good cook but tried making red pesto pasta. Didn’t look great but tasted good.

Post Photo
like

Hi all! Can anyone share recordings of successful McK PEI stories?

likefunny

When doing profitability calculation or NPV, do interviewers usually ask candidates to come up with their own estimates/assumptions for costs, both one-time and recurring?

like

Is IBM Calling back their employees to work from office

like

Any insights on BX London? Specifically the credit platform (ie the ex GSO guys). Culture/comp/near term roadmap?

like

Incoming BA - any advice/links on the math for the best credit card for personal use?

like

What are people's deciding factors between working for a Reseller vs Vendor?

Can sm1 help in calculating in hand salary for below brk up after maxing out 80c and 24A.Thanks in advance.

Post Photo
like

Anyone did a H1B transfer recently using premium processing ? Trying to understand timelines

like

Joining Deloitte. I just submitted my documents to immigration. How long will it take to file my H1B case with USCIS? It’s wired big company like Deloitte is using third party law firm for H1B transfers.

Exec consisting Slalom for more creative work and more diverse and inclusive culture. Any insight into partner and above admissions/roles/past experiences. Based east coast but not looking for local

Any Edward Jones employees? Can anyone share any tips for getting my foot in the door? I’m licensed, have my CFP and have 10+ YOE — However, I’d like to be on the corporate side, ideally in a Product/Analyst capacity. I’ve applied for numerous roles, with no success.

like

Hello friends, is there someone enrolled for BossCoder academy for Faang preparations? please share your review.

like

I’ve been thinking about law school for far too long and want to take the plunge. Where do I start? Any recommendations for studying for the LSAT?

like

I’m honestly tired of being at an agency and not feeling as fulfilled as I used with strategy as a career. Have anyone here make a career change? if so, what other jobs out there - outside of agencies and client side - can you apply what you know as a strategist? Curious if anyone has done it and has some advice.

like

Hypothetical: hiring for a Lead Product Designer position to own direction of a data heavy saas app, would you hire someone that pivoted into UX from marketing and graduated HCI masters recently or someone who had a web designer/dev freelance & UX consulting background?

Just based on those two points.

Can you share what are some questions you're having rn that would affect the decision?

like

Hello! Are there any OKTA recruiters here who I can connect with for HR jobs?

like

Additional Posts in Excel Genius

Hi excel geniuses, how do I quickly copy info from one cell to blanks for same if. Semi below I have products and names, for the blank fields w same product how do I quickly copy for the rest of the blank cells?

Post Photo

What’s the symbol that you can type in a cell so you can input a text, but that text would not appear in the spreadsheet? I want to describe the formula without using a text box, which uses more space.

The equivalent of this is in SQL, you can use the apostrophe in the beginning of and end of a text. That text will not affect the function of the query, but that text can be seen if you proofread the query.

like

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

like

Hello. Quick question about formatting. I have an excel sheet with bunch of negative numbers, but some are percentage values and some are dollar values. Is there a way to make all of them have a parenthesis for being negative while keeping them still percentage and dollar value separately or do I have to target them separately?

like

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

like

Hi there,
Which Excel courses you recommend for a beginner?

like

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

like

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

like

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

like

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

Would anyone be willing to teach me vlookup?

like

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

Does 2-finger touchpad scroll not work on Excel sheets anymore? I used to be able to swipe quickly on my laptop's touchpad to navigate sheets but now it doesn't work. Based on the handful of posts I've read online about it, the problem seems unresolved. Has anyone dealt with the same issue and fixed it?

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal