Does anyone know how to apply the bad/good/neutral formatting to a drop down function? As of right now I can do one or the other, not both

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

Conditional formatting

like

Duh - thank you!

Related Posts

What would be a good salary range to expect as a Senior Business Analyst role in Atlanta, Georgia? Background is 3 years of industry experience in India with a MS in Business Analytics from ASU. Any inputs would be appreciated!! Thanks.

like

All the fin crime people! How does the day to day work look like and you liking it? Any info on pay and wlb will be appreciated! Please help struggling auditor out

like

Hello everyone, I need advise on getting into a pharmaceutical company like Novartis. I have applied to many position but have gotten denied. I know with my experience, Dedication, hard work, and quick to learn new systems I would be a great fit for the company.

like

What would be possible starting salary in KPMG Toronto Hamilton office if you are joining as a 2nd year staff accountant or 1st year senior, working towards CPA. Also, is CPA required at senior level or manager level?

Hi fishes,

I have an offer from Accenture AI with
YOE: 5
Skill set: AWS, Python, Spark
Level: 10
CTC : 19.5 (variable included)

I'm confused if I should go for it as I've heard wlb could take a hit at Accenture

like

EOY review time! Boutique firm with large workload. I’ve signed multiple clients and met my billable requirements in the months I’ve been here. Is a 20k raise request reasonable?

like

Party from TCSers?

Post Photo
like

Anyone have experience working with DISCO (cs disco)? I am wondering about how their platform compares to Relativity.

like

Do we have 4 wheeler loan assistance in Lilly ?
How does it work??

What opportunities does Tax M&A experience lead to?

like
likehelpful

Desi Fam- any nice comedy web shows or movies suggestions in Hindi?

like

5 hour layover in JFK.. any hope to go see or do something outside of the airport for a couple of hours? If yes then anyone have any good suggestions?

like

Why is this bowl dead?

Thoughts on daycare vs. nanny starting at 4 months old?

like

Anyone else on the RSR call today?!

like

As a producer what do you look for in a directors reel before sharing with your creatives?

Additional Posts in Excel Genius

Google Sheets vs Excel - pros? cons? differences?

likefunnysmarthelpful

Ok, using excel is not a primary function for my role (this will be very obvious shortly...) So please be kind! On my sheet, in the first and third columns, I have lists of reference numbers. In the second column I have a client name. I already identified the duplicates in the first and third columns using conditional formatting.What I need to find now is column 2 value, whenever value in column 3 is identified as duplicate. Problem is, I have over 120k rows of data so I can't filter! Help!

like

Please help. I was recently hired by a Venture Capital firm that uses MacBooks instead of PCs. I’m extremely efficient with Excel on PCs and am struggling with the transition to Mac. Do any Mac users have a list of keyboard shortcuts that they use frequently, or any other tips/tricks?

likefunny

Has anyone encountered this error before? We can’t access a workpaper with 70% of the work done 😩😩

Post Photo
like

Can I write a macro that will fill out a table of information based on cells that have comments on them? For example, if G12 has a comment, I want to pull text from that comment + data in A12.

like

I’ve toggled the “Show Formula” setting and it changes nothing. File format is xlsx, so that shouldn’t be the issue. Any ideas why these are showing the formula instead of the output?

Post Photo
like

If you follow him on LinkedIn you probably already saw this! Lol 😆 but I totally resonate with the post... 🤣

Post Photo
funnylike

Best pdf to excel converter?

like

Hey, tips for where to look for good excel cheat sheets online? :)

Tips on adjusting to Mac? I’ve figured lots of keyboard shortcuts but it’s just not the same 😪

like

Anyone know if / how to have the CapIQ and SNL (MI) excel plugins running at the same time? I always run into issues with one of them not functioning when they’re both enabled

Hey Geniuses! I apologize in advance if this question has been asked before, I'm new here and just trying to learn as much as i can. Does anyone know a great source to learn Macros for beginners. I would like to create one for work. I appreciate it

like

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

like

How can I extract just the year into a new cell from a “yyyymmdd” cell (labeled PD here) that isn’t recognized as a date? I basically need to sort this data by year. Thanks in advance!

Post Photo
like

What's the F4 analogy in Office 365?

like

What are your top Excel ninja tricks? Ones that few people know...

like

Hi! I have knowledge of pivot tables, vlook ups. But I'm rusty on if statements and would like more knowledge on excel formulas. I'm looking for excel classes to take online. Any suggestions?

like

Just created my first macro! Super proud of myself! #humblebrag

likeuplifting

I have three lists. Each is a list of processes. Each list represents one hierarchy level. Is there an easy way to get from three separate lists to one list ordered like shown on the right?
Thanks for your help fish!

Post Photo
like

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

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

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