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.

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

Search Conditional Formatting Excel Forums


Conditional formatting!


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


"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


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 conditional formatting with formulas

Related Posts

If I rollover a lump sum from my pension into my 401k, does it have a better opportunity to grow in the future since the market is down?


Hello I looked up the average Patient access supervisor salary in my area and used that to ask for $35x hour but was brought back down to $30. Anyone know if it’s worth this salary? My gut tells me take the job for the experience!

Any single folks on here?


Sneak peek at me on #flyday

Post Photo

More on my plate: a podcast about my work. Working in Blender. Writing a screenplay. The effects on social media. 🤔


Which are the top consulting firms in UK to have great mentorship, learning and development as an entry level business/data analyst


Here’s a light topic: Looking for some good agency meme Instagram accounts, anyone have any suggestions?


At what price will you start buying btc again? I'm looking for sub 20k.


I need your advise. I recently join ey and received offer from another big 4. Who is giving me extra ctc of rs 1.70 lakh after tax and 1 lakh Joining bonus and not ready to increase it more. Is this price enough to leave ey in a one month. Please advise


Can someone explain what’s the difference between EDM technology/tool and DWH?


Anyone in M&A tax at PwC? Looking to get a feel of the current market, culture, and to see how hiring looks.


☝️What's your best hard-earned advice for someone interviewing, job seeking, or negotiating a salary?

Drop it below! 👇


Can someone share Matrimony Confession bowl link.. My friend told me thats interesting bowl... But i don't want to ask her she will easily recognize me by connecting dots....


If anyone has dinnerly and wants to share a free box code with me, let me know!


What do you like most about marketing?


Hi all. What are some of your favorite US based CRM shops? Thanks in advance.


SC to M, promotion in CBO.

I was promoted to SC in Aug 2020, and milestone year shows 2024 (4 years).

Is this normal I thought SC-M was 3 years and 2 for an early promo.

Can anyone suggest if it's even possible to try to get promoted in 2 years? Just don't want to put in extra effort and getting disappointed later.


Hi! Does anyone know where can I find cool off periods for various companies? I am looking for Dropbox at the moment.

Additional Posts in Consulting

Are there any good movies or novels that show skill development - like follow through? Self-management? Money management? I read a lot of self help books so I know a lot of the theory, and books peppered with examples help, but I feel like most 1 paragraph examples don’t five justice to how hard it may be to change a behavior.


Probably a dumb question, but with tech, how did we come up with FAANG? What separates them from companies such as Airbnb, Snapchat, Microsoft, etc.? Some make sense, but the Netflix one is what is holding me up....


At D feeling guilty for avoiding layoffs as I haven’t worked more than an hour a week since WFH began. I automated almost all of my work and told nobody. My PPMD thinks these analyses take hours when in reality I change a few variables in my boilerplate code and say I’m “managing data integrity” for hours


Qq fishes - how much does senior associates make at Strategy&?


Is anyone's calendar NOT up to date??


Flying across the pond. Flying for the first time since Rona. Have terrible anxiety about planes usually but its worse now after this large gap. Tips and tricks to stay sane??


Any thoughts on Udemy vs LinkedIn Learning? Looking to take some courses for building business cases and go to market strategy development. Company provides access to both.


Deliverable week, so time for the MD who stayed distant from this project for the past 12 weeks to all of a sudden have a strong opinion and change all of our deliverables


UK and EU 🐠 - how has COVID affected the business performance of your firm / office?


Does any one know about EY’s spousal travel policy? Any experience using it?


Recommendations for Netflix shows please?


I wear a suit every day that I work from home.


I'm curious- How much is the partner pension in Deloitte?


How’s the benefits at S&? Is it the same as PWC?


Currently looking for Tech consulting/ Implementation consultant/ privacy roles in London. I have both CIPP/E and CIPM.
Please let me know if you know any roles that are available? Or any recruitment agencies you can refer me to


When you're the least experienced on your project yet the only one who can properly use Excel 🙄 #fixingALLtheformulas


Anyone have recommendations for websites with academic/research reports to read or listen to (excluding consulting reports)? I read a lot of books but want to get into more technical stuff with less fluff


If I move to a town a few hours away from my home office, how often am I going to be expected to go into the office on fridays? Seriously considering a move to the beach for my own sanity


Had a variety of R&D related internship experience, but wanted to shift towards consulting and strategy based work after college. Ended up receiving an offer from GH in their life sciences practice. Has been an okay experience so far, but based on what I've seen here on FB, I'm getting concerned about my chances of pivoting to a more legitimate firm i.e. MBB, Big 4, etc. in the future. Thoughts?


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


Embed this post

Copy and paste embed code on your site


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


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