Conditional Formatting Based on Another Cells Values – Google Sheets

Learn how to conditionally format cells and/or rows of data from another range of cells to make a more visual impact.

#GoogleSheets #ConditionalFormatting #Data

[Vinay]

Excellent video. It helped me with the Conditional Formatting of odd-even rows. I was trying/struggling for past 15 minutes.
Thank you so much Ashley!

[nomoretenpins]

Exactly what I was looking for! Thank you for sharing!

[DivineLightProductions]

This was the perfect walkthrough I needed to help me understand how to get the entire row to operate with conditional formatting !!

Thanks a ton!
- Jared

[prithishyar]

Exactly what I was looking for! Thanks so much!! :)

[akash.verma-jsji]

Exactly what I needed thanks for the information 😊

[herbb]

Thanks! The Google instructions were unclear, but this helped me a lot.

[VishalKansagra]

Thank you for sharing this, it is very helpful.

[KT-ewdt]

Ty for making this simple and easy with the formula and single cell or entire cell formatting.

[adeelakhter]

Easy peasy, really helped me in the very simple style

[dersanke]

Hey, is it possible to color a cell if the cell next to it containts a specific letter?
Im trying to get a good layout and would like to see if "A" is next to "B" and so on

[averagedudeusa]

thanks a million! I was able to take that info and apply it to a similar, but different scenario and it works!

[WajidAli-nklx]

Thank you so much. I want to add these completed projected to another list or want to count their value to specific cell what should I do?

[shikharkaul]

is there a way to do it based on qualitative factors of another cell? like if another cell is bolded make this one too, or if another cell is green, make this one red etc

[shraddhasingh]

Thanks for the tutorial..it's very helpfull

[JayByrd]

Are you able to conditional format the boarders also in google sheets?

[dodoagung]

Thank you, hello miss, may I ask. How do you format conditions on different sheets

[DorothyOBrien-ox]

Is there a way to do this for a date range rather than a text string? I want to create a condition for column "B" when the data in column "C" has a date within the current calendar month.

[marksibert]

Hi. I wonder how you can have an open set of fields that you want to be flexible with, and change the individual cell's format, but a group of fields that will individually change to those formats when you put in just the word?

To explain my self. I have a list that could say and formatted --

unassigned - white field, regular black text
start - white field, bold black text
in progress - blue field, bold yellow text
80% complete - green field, bold yellow text
etc...

and the list grid will have the single fields change to those when I just enter the word.

but I also want to add a differenct word and format whenever I want, that will change in the grid's individual field too.

[ZhaoYun-texb]

Hey. What if the cell that we refer to is a formula but we want the value?

[firdausasas]

Hey I have a question.
What if the cell says "Sunday" but it's actually a date that I format to display days