Conditional Formatting Based on Another Cells Values - Google Sheets
HTML-код
- Опубликовано: 22 авг 2024
- 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
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
Alright I think I spoke to soon! Lol… maybe someone can help…?
I have a Google Form that is linked to a spreadsheet. I’m trying to add another column to help me manually select/track the progress/status of data that comes into the Sheet from the Form. In that status column I have “Complete” as a drop-down menu item, and I’m trying to make the entire row have conditional highlighting. But this method you teach in this video isn’t working for me… :(
Do you know why that might be…? The only thing I can think of is that it won’t work with a sheet that is linked to a Form where data is automatically recorded to…?
Ty for making this simple and easy with the formula and single cell or entire cell formatting.
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!
Thanks! The Google instructions were unclear, but this helped me a lot.
Exactly what I was looking for! Thank you for sharing!
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?
thanks a million! I was able to take that info and apply it to a similar, but different scenario and it works!
Easy peasy, really helped me in the very simple style
exactly what i needed! thank you
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.
Thanks for the tutorial..it's very helpfull
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.
Brilliant - many many thanks
Thank you Ms Cameron!
I wonder how to make each of the world name have different colour?
Is it a formula or you do it manually?
This actually WORKED!!!
Thank you, hello miss, may I ask. How do you format conditions on different sheets
Great tutorial. Thank you very much
Hi. My goal is to find a way to copy a cell and text color to copy the origination of a cell's and text's colors. For example, cell a2 has the word "completed" and the text is bold red with the cell's color purple. When I type "completed" in cell c35, it automatically makes that cell's color purple, and the word becomes bold and red.
How can I do that without a script?
Wish I saw this last year, but now I know.
Are you able to conditional format the boarders also in google sheets?
Thank you for this tutorial 👍
Very Helpful, Thanks
Exactly what I needed!!
what if i want the row to change color only if a certain column is not empty.
Foe example, I want
1) If column a3:a is not empty, the color should change to green
2) if column AH3:AH contains any date (not certain date), or is just not blank, color should change to red
Hey I have a question.
What if the cell says "Sunday" but it's actually a date that I format to display days
Thank you for sharing this, it is very helpful.
Exactly what I was looking for! Thanks so much!! :)
Hey. What if the cell that we refer to is a formula but we want the value?
Exactly what I needed. Thanks!
straight forward, to the point
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
This does not work in my case, I have a description in column A, I have column X value derived from countif function, which ranges between 1 to 7, I want colour of cell in column A changes when column X value reaches to 7. This formula described in video does not work for my google sheet
Brilliant!
VERY HELPFULL
Not working for me. Equal sogns result in red amd wont go away.
i have a question: i want that the formula will take value from a cell. how can i do it?
Exactly what I needed thanks for the information 😊
Heartiest thanks .
Very helpful!
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
Thank you so much mam ❤️
Was of help, thank you.
Thanks for the video!
Thanks a lot. .Thats helps.
Please use mic for more sound
Thank you
I have a question, "for example if A is 8 , B is 10", how to colour Cell A if Cell B is bigger than Cell A? thanks
using A2 as cell A and B2 as cell B, it would be "=B2>A2" for the formula
Thanku ❤
👏