Related Posts
Additional Posts in Consulting
Is UCLA MBA target?
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
Is UCLA MBA target?
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Download the Fishbowl app to unlock all discussions on Fishbowl.
Copy and paste embed code on your site
Send download link to your phone
OR
Scan your QR code to download
Fishbowl app on your mobile
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
Yes conditional formatting with formulas