Conditional formatting is the greatest Excel feature ever and I will fight anyone who disagrees. What are your must-know formatting tricks?

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

Meet me in the parking lot

funnylike

XLOOKUP, conditional is great, but XLOOKUP is better for my daily use purposes.

like

Considering that =XLOOKUP() is the worst lookup formula - by virtually every objective metric -, OP would win this easily

like

Customized number formatting rules are very powerful too, as long as you know how to use it properly. You can change number scale, color and a lot of other things.

like

Do you have an example/formula?

like

That's an interesting take... My job would suck without sumifs or lookup formulas, so those I guess

How does one learn more about Conditional Formatting? I am intrigued

Lots of good articles. ChatGPT isn’t very good for looking (so far) but a basic internet search…. Just remember to include the version of Excel you got.

Not gonna fight you but let’s compare and confuse the heck out of everyone around us!! With what I do conditional formatting has minimal impact so I end up saying index/match or power query of the power houses. I hate pivots but that’s all the look at so conditional is more for me then them.

Related Posts

For those of you without a home office: Where do you usually work? My desk is in my bedroom and I’m considering sacrificing aesthetic to move my set up elsewhere

like

Does anyone have any book recommendations for information on buying a house?

like

I just received a notification that I received a VM on my cell phone...

The message was left for me on 2/26 ...

Seems my cell service caught the 'VID from the USPS

like
like

Can someone please help me in getting project description related to LWC (Salesforce) for 2-2.5 yr experience, so that I can take reference and add in my CV?

like

Hi Fishes,
My LWD in Wipro (my previous employer) was on 21 Aug, 2021. I was waiting to receive my outstanding due and experience certificate, as part of F&F, ever since. However, I received an email from the offboarding team today stating that my Final Settlement is on on hold due to security concerns (DLP: data leakage). How is this going to play out? And much longer will it take before my F&F process is completed and I get my outstanding due and my experience certificate? Pls advice.

like

I’m trying to decide on a hotel in the Maldives - currently choosing between the W Maldives and the Park Hyatt Maldives.

Does anyone have a perspective based on experience?

Is there any difference in negotiating before year-end vs. in January? Will more budgets release in January making it easier to get sign-on bonuses etc.?

like

I've worked with the client for over 7 months now and he still calls me by my dad's name
What do I do 😭😂

like

Can anyone share the questions PwC AC Kolkata will ask for interview in assurance for CA as A2/SA1?

Hello,
My skillset: Oracle Identity and Access management, Java , YOE:3.5

My current CTC is 8lpa, i have an offer from VFISLK 11lpa, and expecting offer from Accenture 12lpa.

Can Wipro match the offer?

Considering wlb and job security, i can stay in Wipro if they match the offer.

like

I am currently pursuing my B.tech in IT. I wish to work as an intern at Paypal Singapore. Can anyone tell me what's the criteria for selection and whether paypal sponsors visa?
Any help would be highly appreciated!

Whats the scene for sabbatical leave at amex,
I have been here for over a year now.

Whats the eligibility criteria? How to request one? Etc.

Thanks in advance.

like
like

I have given interview in LTI on 20th August which was pull campus so L1,L2 and HR all three rounds over on same day and I was told in HR round only that you are Final Selected. I got documents submission mil on 22nd August and I submitted it, But till now(2nd September) I have not got any mail for offer letter. How much time it will still? Can anyone help me on this?

Note- I received one email having Subject Line- Application status has changed(which was system generated).

like

Any Directors, Assistant Director, Executive Director from PwC. I need some information regarding the final round/ED round mentioned in my email.
PwC PwC

Are Mastercard, AMEX, Visa - Product based companies??
Also, what would be the best choice for data engineers?

How much is the notice period in KPMG india?

Any recommendations for best balance transfer card? Like zero APR for 15-18 months and no fee? Also nice to have points or cash bonus

like

Booking a last mintue trip to India over Christmas New Years. Anyone have any tips on best places to book business class? From JFK.

like

Additional Posts in Excel Genius

Would anyone be willing to teach me vlookup?

like

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

Best websites to get more of a handle on Excel as a beginner-intermediate?

like

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

like

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

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!

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

like

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

How do I compare two sheets to make sure they are identical?

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

I’m helping my GF with excel and need help lol. She works at a hospital and is trying to make an excel schedule for doctors to reserve rooms. She wants drop downs for days of the week (column K) and also different drop down menus in column P for the reserved time slots.

Is it possible to do this with two sets of drop downs (days of week + time slots) and not use index match here? She could make 5 tables for each day of the week, but prefers one table that can be easily navigated by doctors.

Post Photo
like

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

like

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

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

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

like

How do I change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down

like

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

likesmart

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

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

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