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
Пікірлер: 49
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!
Exactly what I was looking for! Thank you for sharing!
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
@DivineLightProductions
Жыл бұрын
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…?
Thanks! The Google instructions were unclear, but this helped me a lot.
Exactly what I was looking for! Thanks so much!! :)
Ty for making this simple and easy with the formula and single cell or entire cell formatting.
Exactly what I needed. Thanks!
exactly what i needed! thank you
Easy peasy, really helped me in the very simple style
Exactly what I needed thanks for the information 😊
Thank you for sharing this, it is very helpful.
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?
Exactly what I needed!!
Wish I saw this last year, but now I know.
thanks a million! I was able to take that info and apply it to a similar, but different scenario and it works!
Thanks for the video!
straight forward, to the point
This actually WORKED!!!
Thank you for this tutorial 👍
Thank you Ms Cameron!
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.
Thanks for the tutorial..it's very helpfull
Very Helpful, Thanks
Heartiest thanks .
Very helpful!
I wonder how to make each of the world name have different colour? Is it a formula or you do it manually?
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
Was of help, thank you.
Thank you so much mam ❤️
Are you able to conditional format the boarders also in google sheets?
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
Thank you, hello miss, may I ask. How do you format conditions on different sheets
Thanks a lot. .Thats helps.
VERY HELPFULL
Brilliant!
Hey I have a question. What if the cell says "Sunday" but it's actually a date that I format to display days
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. What if the cell that we refer to is a formula but we want the value?
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
Great tutorial. Thank you very much
Thank you
i have a question: i want that the formula will take value from a cell. how can i do it?
Not working for me. Equal sogns result in red amd wont go away.
Thanku ❤
Please use mic for more sound
👏
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
@lyndongarza3485
Жыл бұрын
using A2 as cell A and B2 as cell B, it would be "=B2>A2" for the formula