Conditional Formatting based on Text in Another Cell - Tutorial

In This Video Learn how to do Conditional Formatting Based on a Text in Another Cell, in Excel. You will also learn an amazing Formula to use along with the Text based Conditional Formatting.
Don't Forget to Subscribe..
🔶 Get the Practice Excel File Here : bit.ly/3uZnFmA 🔶
Digital Products:
🔷 gumroad.com/te... 🔷
Must Watch Playlists..
Excel Tutorials:
• TEKcel Series : Excel ...
Excel Chart Tutorials:
• TEKcel Chart Tutorials...
Excel Pivot Table Tutorials:
• Excel Complete Pivot T...
Excel Gsuite Tutorials:
• Gsuite Tutorials
Excel Tips & Tricks:
• TEKcel Tips : Excel Ti...
Powerpoint Tutorials:
• Tekpoint Series : Powe...
App Reviews: • Apps
Gadget Reviews:
• Gadget Reviews
Thanks for watching!!! 😊🙏
Please do Subscribe and Hit the Bell 🔔icon to receive all my videos Notifications.
CLICK HERE TO SUBSCRIBE 👉 tinyurl.com/Te...
Follow me on below to stay connected👇
👉FaceBook: / teknisha
👉Instagram: / teknisha18

[@evidencefrank4643]

Thank you so much for this video. It's self explanatory and easy. It helped me to solve a problem now. More strength, Sir!

[@TeamCidroTV]

Thank you It's helpful and very easy to understand :)

[@pritikaur-jenkins7973]

This is very helpful! Can you advise if so can highlight the whole row, based on the text in a single cell? So if the cell contains “Closed” the row turns a colour?

[@jayaprakasharjunan]

You are really doing magic🤩, Thank you, congratulations, Thanks for sharing

[@TEKNISHA]

Thank you for the comment.. Glad that this helped you….

[@randirandana8974]

well, this tutorial really help me. Thanks

[@TEKNISHA]

Glad that it helped you

[@DevenGavlee]

Hey bro, kind of silly but thanks for this video . It really helped. 🤩👍

[@TheGuyThatWondersWhy]

I’m looking to make the conditional formatting of one column based on another with text. So say B1 cell will change to “Hi” if B4 is “Bye”. If I can B4 to “Go”, B1 will change to “No”.
How can I do that?

[@maverick19_]

No reply??

[@narasingaraoguggilapu208]

Tq sir the best information given

[@TruthofDilly]

Excellent thank you

[@maryjosephezehchisom6605]

Thanks😘

[@TEKNISHA]

You're welcome 😊

[@revathilokiah1219]

If I want one specific text value reference from another dropdown cell, how can we do it?

[@michaelgarcia5356]

Hello Teknisha, I am working on the conditional formatting however I have a different color per drop down, so that the selected boxes in the sheet will change colors based on the drop down. can you send me something regarding that?

[@deyanzhelev3438]

Thanks

[@agungandriansyah6646]

Thanks brah

[@HonestLivingLLC]

Hello, I’m trying to highlight a row in green if the row is all filled in and highlight it red if it’s not how can I do that.

[@amsoua5]

thanks

[@m.n.953]

Thank you sir for nice and clear video, I have a question pleas. I make a table that contains in culomn A doctors names and the headers in row1 is the month date. Inside the table all the cells has data validation with departments in hospital to make a monthly rota shift for the doctors. The list of the data valedation contains (main department, long shift, short shift, emergency, operation room, DAY OFF).
I want to make a conditional FORMATING THAT IF I CHOOSE "long shift" from the data validation automatically gives this doctor "DAY OFF" for the next day and color the cell of "DAY OFF" in red.
How can I do that.( For example if I choose in C5 "long shift" automatically mak D5 "DAY OFF" with red background in B5.) thank you.

[@nancypaslein691]

How to do this (Names of the students ending with the letter y, pattern colour blue) help

[@cassandrathatsme4382]

interesting.....
But, what if I wanted to have all cells that say Daily in Green, Fun in Yellow, and Another in Pink, all in the same column. Is that possible? It is odd that you only showed us how to turn cells green given the prompt 'Daily, Fun, etc, and never had more than one color displayed in the same column.
There are many times we would need to see multiple colors
For instance, I wish to see every Third number starting with '#1'' in Yellow. Every third number starting with '#2' in Green. Every third number starting with '#3' n Blue. And any '0' in Red. .....All in the same column.
Is this possible?

[@alesandroalbert]

What if I want to highlight all the rows that contains "DAILY"

[@NavidAhsan-pf7vj]

how to do in exile sheet if I click on a cell and a cell has text "home" and all sheet cells are highlighted with the same text and when unclick then it goes to normal

[@BoyFromMa]

I want to highlight the entire row!

[@TEKNISHA]

Check this video to highlight entire row. ua-cam.com/video/QHhMb5voO6s/v-deo.html

[@NavidAhsan-pf7vj]

I
have 1200 categories how i can add them?

[@ahmedzaghloul1429]

OOF IN THE INTRO I THOUGHT IT WAS AN AD

[@userfree5885]

how to make a cell turns red if another cell contains date?
what is the rule ?

[@shakirabanulattannavar743]

Hi I have one scenario similar to this. Can you help me

[@TEKNISHA]

What is the scenario?

[@sonyamoore3593]

I'm trying to create a financial spreadsheet. I want to say, if my balance (B7) is >50% of my allocation (B5) I'm green, If my balance (B7) is between 30%-45% of my allocation (B5) I'm yellow. If my allocation (B7) is

[@TEKNISHA]

Hey Sonya,
You will need 3 Conditional formatting rules. However I would suggest that you need to have continuous ranges >50% is green 30-50% (not 45%) is yellow and (0.5)*B5
Second will be
and(B7 > (0.3)*B5 , B7

[@kirandeepelectricals5199]

PLEASE RAISE YOUR VOLUME

[@CampfireGuitarHero]

could'nt hear you properly so clicked away. Louder volume next time please.

[@diwwy_9912]

Thanks bro

[@TEKNISHA]

Welcome