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..

Digital Products:

Must Watch Playlists..

Excel Tutorials:

Excel Chart Tutorials:

Excel Pivot Table Tutorials:

Excel Gsuite Tutorials:

Excel Tips & Tricks:

Powerpoint Tutorials:

Gadget Reviews:

Thanks for watching!!! 😊🙏

Please do Subscribe and Hit the Bell 🔔icon to receive all my videos Notifications.

Follow me on below to stay connected👇

[evidencefrank]

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

[pritikaur-jenkins]

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?

[TeamCidroTV]

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

[jayaprakasharjunan]

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

[randirandana]

well, this tutorial really help me. Thanks

[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?

[revathilokiah]

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

[michaelgarcia]

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?

[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.

[damiansojka]

How to color column next to it based of text ? So example: If D4 is "internet" color C4 ?

[Onlyviral]

Can we make the same formula in Google sheets

[DevenGavlee]

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

[NavidAhsan-pfvj]

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

[nancypaslein]

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

[m.n.]

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.

[alesandroalbert]

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

[cassandrathatsme]

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. in the same column.

Is this possible?

[NavidAhsan-pfvj]

I
have 1200 categories how i can add them?

[shakirabanulattannavar]

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

[userfree]

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