Column A - activity completed (yes/no)
Column B - overdue (yes/no)

How do I make it so column A is red (cell says no), when column B is overdue (cell says yes)?

I’m so bad at excel.

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

Search Conditional Formatting Excel Forums

like

Conditional formatting!

like

Select the first cell and go to conditional formatting-Use formula to determine...-type =and(A2="No", B2="Yes")-but replace A2 and B2 with the correct row and column in your file-set your formatting then paste formatting down entire row

like

"Do or do not, there is no try."

You put your right foot in. Then take your right foot out. You’ll then want to put your right foot in - and I can’t stress this part enough - and shake it all about

likefunny

Which foot is right and which is wrong?

Conditional formatting for specific text and then add a drop down box for yes/no selection if you want

I understand conditional formatting in a specific column. But can it work between two columns?

Like I only want column A for status red IF it’s overdue in column b. Is that conditional formatting?

Or I don’t need the overdue status red if the the activity completed column is green/yes. There’s logic for it to be red if past the due date, but being past the due date doesn’t really matter if the activity is completed

Yes

like

Yes conditional formatting with formulas

Related Posts

Why are average salaries in UK and EU looks much less compared to US for similar role, even with higher tax rates? Is it factoring in benefits such as free healthcare, education etc? Or is it just a matter of demand/supply?

like

I spent the most part of my 1 hour group yoga session trying to hold in a apart 🤫

likefunny

Legal walo k liye bhi offices are opening kya🥺
P.S- this is for GDS. I know it's WFH till dec.
Just wanted some clarification for 2022

like

Are brand manifestos necessary? I’ve been doing branding for 12 years and both agency and clients put so much focus on it but it never really gets used/read after project is live.

like

Junior bankers in NYC — are y’all even allowed to get tired? Are you legit productive 90% or more of your day, EVERY day?

like

My h1 transfer in progress for an offer but I got another yesterday which is the better offer. Can I get two h1 transfer at a same time? Did anyone face this situation?

like

hi everyone
second-year Economics student here! I want to land an internship in capital markets for next summer but it has been really hard to be seen and ensure an offer. It is already too late? Any recs? Is anyone still recruiting for next summer?

like

What do you find oddly attractive in your man? Woman? I’ll go first!

I love when he wears leggings under his basketball shorts. Oooouuuuu weeeeee! It really does it for me 🙃

likefunny

Perspective is a funny thing. If you are convicted of a small crime, you may be punished with community service. If your company offers "great benefits" they may include community volunteer days. Do criminals have better ESG scores than me?

funnylike

Can we get our experience letter from Deloitte USI while we’re serving the notice period?
Please confirm.

like

What is your general opinion of Teachers' Unions which protect teachers from being removed based on their poor pedagogy over many years?

Can you get back Virgin Atlantic miles spent on booking a reward delta international flight if you cancel the flight due to coronavirus?

like

Wondering what some slightly less well-known consulting companies are (outside of MBB, B4).

Can anyone refer me to @Kearney, @Oliver Wyman, or other consulting firms they enjoyed working in? Thanks!

like

"Enoch walked with God…" -- Genesis 5:24

"The true test of a person’s spiritual life and character is not what he does in the extraordinary moments of life, but what he does during the ordinary times when there is nothing tremendous or exciting happening." -Oswald Chambers

upliftinglike

I think I’m addicted to adderall. I can’t stop taking it and I don’t think I can quit b/c of the pressure of the industry. I’ve been up for 2 days and I’m exhausted. Any advice?

like

Is there any KPMG / AA or Delta status challenges going on right now?

like

Starbucks is notorious for having bad coffee...but which of their brews is the best? If you absolutely had to go, what are you grabbing?

like

Hi everyone, 2nd year junior associate going on my 3rd year - working in big law . Got staffed on my first corporate financing deal and I’m completely new to this (usually do private M&A deals) . Super happy about this new opportunity but also kinda freaking out. Really want to make a good first impression and do good job on this deal? Any tips ? ☺️

like

It throws me off every time my co-worker tries to make me feel dumb by saying:
Cont'd

Additional Posts in Consulting

All these staff and seniors thinking they're 5s for doing their f'ing jobs. Get a grip y'all.

like

Just worked my ass off on a BD project while staffed full time on a project. MD didn't even invite me to the client meeting to show off the product. 😡

like

Experiencing significantly more back pain since the last month. The work setup hasn’t changed. It’s a generic desk, footrest and ergonomic chair. Suggestions welcome on what I can add to my setup to make it more comfortable. I do take breaks and stretch once in two hours.

like

And with that mouse click, the 6 figure student loans are paid off. F you Fedloan, and all of your BS over the past 3 years. Freedom!

likeupliftinghelpfulfunnysmart

Currently a C at Deloitte (3.5 years since graduated UG) in my promotion year to SC. Being reached out to for project manager role at slalom. Would this be a good step up? Or stay put?

like

Suggestions for things to do in Nashville for a few days? Best coffee shop and bar recommendations?

like

When your front-line clients send you a Snapchat of them singing Ke$ha's "Prayer" song with modified lyrics describing the shittiness of your tools

likefunny

Feeling really burnt out, on H1B. Can't just take a break from work, also no utilization in this environment is detrimental. What can I do?

like

Do you believe work life balance can work in strategy and consulting? I personally do not...

like

Who cares about saving the real world now that everyone is building the 'metaverse'?

like

Do recruiters see your internal reviews? / would they request them?

like

Is UCLA MBA target?

like

Wanted to know how different is management consulting in the US via-a-vis India?

Background : working as front end consultant in India. Daily routine is opening laptop at 9AM and doing work till 10ish PM, if the project is tight (which it is in majority cases) closing laptop by 1 or 2 am. Travel depends on project. Sr Managers have no sense of personal space in most companies. Money is goood.

How are things in US as I wish to join consulting in US for a few years for int’l exposure

like

Hey 🐟 sometimes there's a lot of negativity or pessimism on fishbowl and I wanted to create a new bowl where people can share all of their happy moments to remind others to look on the bright side ❤️

like

I keep taking calls with companies because I get some actually good offers on LinkedIn (I work in a growing area of health tech) but I have no intention of switching companies at the moment. I like to test the market. What is the proper time to stop interviewing? I don’t want to waste anyone’s time but I’m also obviously passively willing to chat and look around at opportunities

like

Time to board the flight. Bulldog? Check. iMac? Check. Seems like a better option than mine.

Post Photo
likefunny

Thoughts on Bloomberg NYC? Looking for any insights on people, pay, work life balance, etc.

like

Has any of you had any luck joining another firm as a partner while not being one at your current firm?

like

Are all the Olive layoffs just due to preparing for the recession? So sorry to everyone who was laid off

like

Anyone else trying to finally kick that nagging cough/cold before the break? Would hate to have any option short of “all the booze” while I’m on vacation.

likefunny

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