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…?
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.
hello Ashley i have a doubt we have a column with one conditional formatting format rule "in between" that highlights only 1 cell how to highlight the entire row when the "in-between" rule is enabled?
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.
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
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, 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
is it possible to have one cell that has a number in it, automatically add a number each month? If I have a number and want it to increase by 20 each month automatically, is this possible?
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?
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
![[#2024MAMA] BIGBANG (빅뱅) - 뱅뱅뱅 (BANG BANG BANG) + FANTASTIC BABY | Mnet 241123 방송](http://i.ytimg.com/vi/EQsYfiPR9uM/mqdefault.jpg)
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…?
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!
This is EXACTLY what I needed to learn to do!! Excellent! Mahalo, Ashley!!! 🙂
Wow, the easiest explanation ever, thank you
Exactly what I was looking for! Thank you for sharing!
Thanks! The Google instructions were unclear, but this helped me a lot.
Exactly what i came looking for. Thanks!!
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
Ty for making this simple and easy with the formula and single cell or entire cell formatting.
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?
This actually WORKED!!!
Thanks for the tutorial..it's very helpfull
Exactly what I was looking for! Thanks so much!! :)
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.
hello Ashley
i have a doubt
we have a column with one conditional formatting format rule "in between" that highlights only 1 cell
how to highlight the entire row when the "in-between" rule is enabled?
Exactly what I needed. Thanks!
Very Helpful, Thanks
Thank you, hello miss, may I ask. How do you format conditions on different sheets
Great tutorial. Thank you very much
Thank you for sharing this, it is very helpful.
Exactly what I needed!!
Are you able to conditional format the boarders also in google sheets?
Brilliant - many many thanks
Exactly what I needed thanks for the information 😊
Very helpful
This made my sheet highlight the line above the cell instead of the actual row
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.
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
straight forward, to the point
this Fk $ sign, almost broke my head. thanks!
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, 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
Wish I saw this last year, but now I know.
I wonder how to make each of the world name have different colour?
Is it a formula or you do it manually?
is it possible to have one cell that has a number in it, automatically add a number each month? If I have a number and want it to increase by 20 each month automatically, is this possible?
Thanks for How to product the same sheet but multiple user control in same sheet
exm, A column only edit Mr. A B column only edit Mr. B how to do this
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?
Very helpful!
Thanks for the video!
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
VERY HELPFULL
Heartiest thanks .
Hey I have a question.
What if the cell says "Sunday" but it's actually a date that I format to display days
Was of help, thank you.
Brilliant!
Thank you so much mam ❤️
Hey. What if the cell that we refer to is a formula but we want the value?
Thanks a lot. .Thats helps.
i have a question: i want that the formula will take value from a cell. how can i do it?
Please use mic for more sound
i WANT TO COLOR A PERTICULAR CELL FROM MAX (RED) TO MIN (GREEN) IF THE CELL TO ITS RIGHT IS 0 RESPECTIVELY
Can please help I am at my wits end
Not working for me. Equal sogns result in red amd wont go away.
Excelent - which I want.
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
Thank you
👏
Thanku ❤