I am learning google sheets for my own personal use and your videos are easy to understand and encouraging. I appreciate that you generally focus on one formula or action per video. Thank you.
This is the #holyGrail of Google Sheets, bro! You make it so simple to understand. Changing a whole row based on the contents of a cell in that row is something I find myself having to often. I am bookmarking this
I use Sheets for maintain a game collection of Digital, physical and free games given with subs, you showing how to move the position of the formulas to show which one has preference was a big help since I couldn't figure that out (which kills me how dead simple it is to move them around lol)
I was working a ToDo list and Camping Packing list that would strike through the item in the cell when a checkbox was changed too TRUE. Nailed it! Your video was quick and just what I needed. Now when the checkbox is clicked that cell changes color and the text in the adjoining cell gets struck through...just like a my old fashioned hand written lists. Now my girlfriend and I share lists on our iPhones/iPads and when one of us completes a task or verifies we have packed an item the other can easily see it so we don't do things redundantly or forget something altogether. Much appreciated!!
This video helped me immensely! Creating a sheet to tally attendance, wanted to have the "name" column change colors based on if the required events were attended. Used a countif in a different column to tally attendance and used your video to change the color based on that value. thanks a ton!
Great video thanks. Is it possible to format one cell based on anther cell equaling a DATE? Any date, i.e. if the other cell has text or formula than no format but if a date is entered then it changes color? Thanks for your consideration. ANSER FOUND: =isdate(B2) Where B2 is the cell with the referenced date
I found this useful, may can relate: Create an Event Reminder use Color | Status: Finish; Today; Three Days Until 1 Day Before Event ua-cam.com/video/7FdByf2TEo0/v-deo.html
Can this be done to change the color of a cell based on if its value is , or = another cell? I am wanting to use the sum at the bottom of a column to compare it to a target number in another cell and each cell change based on the comparison to the other. For example if A4 is > G18 then both cells would turn red to indicate that the target number has not been reached but it would change to green when they are equal based on the sum of the column G.
I've been watching all your Google Sheet videos and they are extremely helpful. I'll be sharing them with friends and family. I think I can use this for attendance records.
Great video. would love to see a video on how to to conditional formatting based on the percentage of a number in a different cell. Example: Goal Tracker spreadsheet: Goal Sell 100 pens per week. and in subsequent cells we add weekly sales updates. Cell A1: 100, Cell B1: 90, C1: 100, D1: 75, etc. Then the conditional formatting shows a colored background based on level of success. 0% achieved, or 0 sold in this scenario is red, 100% achieved or any sales 100 or more is Green. the cells would shift from red to green as you reach your goal each tracked week. High quality stuff here though. tag me if you create this video!
I have a sheet with data of 20 players where the players data is given one after the other, but separed by players in the same column and I want to highlight in different shades of green the 3 highest in investments, the 3 highest in net Value etc in Google drive, how do I do that?
Hello! I would like to highlight a cell range and remove the highlight once a text in a certain cell appears. Would it work on your sample? Appreciate your help. Thanks in advance!
I have watched a few videos on conditional formatting in hopes of what i am looking for! But I cant see to find it :( I have a drop down menu (yes, no and pending) in column "B" and in column "A" I want it to reflect the number "0" when "No" is selected. How do I do this?! Am I researching the wrong equation? Ha! Thank you!
Hello. How to color the whole row if the first cell is not empty? I don't know how to enter the formula. Is there documentation? Edit: I find it: =$A1>0 Edit2: I think this entry is more correct =$A1""
Hi. New subscriber here. Im just curious if it is possible to put a automatically put the date today when I click on another cell. Because I use sheets for studying. For example I clicked A2, A1 will show the date when I last edited or click. What I do now is manually putting dates to track when I last studied a specific row. Thank you.
I'm trying to track my weight. I want the conditional format to be green if the weight is less than the last recorded weight and red if more than the last date. I did it for the second weight, but when I tried to copy it down for the rest of the month it only compared every weight entered by the first weight. How do you set it up with relative references? Alternatively, how to you copy and paste conditional formatting?
Was wondering if you had a values in column B and you had a vlookup placing values in cells column C. How can you conditionally format if B2 doesn't equal C2, and B3 doesn't equal C3. When value in rows in c doesn't match the values in Column b then I should see cells in column C highlighted. IF #NA appears in Column C that should also be considered as not matching.
Hi I am trying to to use a combination of conditional formatting and "blank" cell, but i just cannot find how to do that anywhere. eg=NETWORKDAYS(B3,C3,Holidays!C59:C67) i have this formula to calculate how many days from one date to another, then adjacent to that column i have this formula =NETWORKDAYS($B3,$A$1,Holidays!C60:C68) to show how many days it has been in real time. This is where it becomes tricky, the next column i enter an end date but the clock keeps on ticking. I want the clock to stop and the cell to go Blank, when i add the end date. Do you have any ideas?
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?
Thank you for the explanation. But it doesn't solve my problem. I'm using Google sheets for excercises accounting for my high school students. In stead of having to correct each excercise manually, I want to use a kind of autocorrection. I want to complete each excercise with a sheet in which I can copy the correct solution. When this is done, cells in the solution of the students which aren't correct, should light up in red. But is more complex than that. In accountancy it doesn't matter if A proceeds B: when B proceeds A the solution can also be correct. But in my solution I might have A proceeds B and the student can have B proceeds A. In that case the cells would lighten up red, while the students solution is still correct. Can you help me out?
Just tried following your steps and it's still not working on my end. Not sure if I'm doing something wrong. I'm trying to have a cell highlight a specific color when the next cell over has text inputted in. For example, I'm trying to highlight cell G23 in green when cell H23 has the word "Yes" inputted in. Any help will be appreciated. Great work with the video. I just subscribed!
I am learning Google Sheets/Excel for a variety of uses for research and data management uses for private investigation work. I use a mobile device for most of my work so it's extra tricky
on my google sheets i don't know how this happing: row6 and 7 color keep changing to white i change back to black and if you go to next column it again writing white: is there any solution PLEASE
Excellent video. I am trying to highlight a cell when someone makes a change. I am sending a sheet to about 8 people for their updates and I want to track them. Is there a way to use conditional formatting to color a cell when it is changed?
I am constantly trying to turn a value red if another value equals something. Like if I used a credit card in my budget I want the amount I spent to show up red. I'm loving your videos, so easy to go down the rabit hole. . . I think I'm about 5 videos away from where I started with one of the budget videos.
When a date is input into a cell, Iwould like to use conditional formating to change the colour of another cell within a calender so that it highlighted. Any help/advice would be welcomed. Thanks
@@whyworksmarternotharder Thanks for the video but its not quiet what Im after. I have a calender which extends over a 5yr period. I would like the calender to be dynamic in that I have a series of dates (associated to tasks) which when input into an adjacent colum I would like the cell in the calender of that date to be highlighted. Any ideas how I could so this?
Hi! You helped me a lot, but I have a question. You said in your formula that the name would become red if no text was in certain cell, which was translated as "=C4="" (the quote marks empty because cell is blank) but what happens if I want it to change the name to green by adding any text? What do you need to include in the formula between the quote marks to indicate that any text written in there will affect the other cell's color? I don't know if I explained myself properly.
Hi.. liked yr video & you hv great explanation skills. Bravo! I hv a specific question.. pls if you can resolve for me.. There is set a transactions on my googlesheet and need to highlight the rows which have Unpaid Bills. The particular Cell (Payment value Cell) has three scenarios: 1. Empty - bill unpaid - the entire row to be highlighted in Red 2. Payment value Cell - Value is equal to Invoice value (This value is already in next Cell - same row) then No colour - non highlighted. 3. Part payment - if Cell Payment Cell is less than Invoice value - then entire row must be highlighted in Yellow. Hope you got it. Thks!
I followed the steps meticulously, but even with the dollar sign in the formula and the rule at the top of the list, the row is not changing color! Help!
Setting up a fantasy hockey sheet and trying to make a group of cells to turn red if a teams budget in a certain department ($10,000,000) For some reason there's 3 cells that just won't change color like they should. Just a glitch, or am I doing something wrong? Formula I used was... =G153
Good videos and thank you for your content. But, what's with the intro music always being 3 times the volume, I have to turn you up to hear you and then I worry my speakers are going to blow when your intro music plays.
I'm needing to change colour of number based on value of cell above. IE number in A3 is lower than A2 (make red) if higher turn blue. Its easy in excel, but Sheets has me stumped. 😅
I am learning google sheets for my own personal use and your videos are easy to understand and encouraging. I appreciate that you generally focus on one formula or action per video. Thank you.
So much better than the google sheets help site! Using this to keep track of daily word count goals. Thank you
This is the #holyGrail of Google Sheets, bro! You make it so simple to understand. Changing a whole row based on the contents of a cell in that row is something I find myself having to often. I am bookmarking this
Hi, i want to ask that the symbol for empty is "". Then how about not empty? What is the symbol for not empty in google formula
Thank you for putting these videos together. I have found them very useful in completing a multitude of tasks.
Using this to help me with my budget sheet and color coding expenses! This was so helpful thank you!
I use Sheets for maintain a game collection of Digital, physical and free games given with subs, you showing how to move the position of the formulas to show which one has preference was a big help since I couldn't figure that out (which kills me how dead simple it is to move them around lol)
I was working a ToDo list and Camping Packing list that would strike through the item in the cell when a checkbox was changed too TRUE. Nailed it! Your video was quick and just what I needed. Now when the checkbox is clicked that cell changes color and the text in the adjoining cell gets struck through...just like a my old fashioned hand written lists. Now my girlfriend and I share lists on our iPhones/iPads and when one of us completes a task or verifies we have packed an item the other can easily see it so we don't do things redundantly or forget something altogether. Much appreciated!!
Thanks for the video!. A faster way to check or uncheck a lot of boxes at once is, select all the boxes and hit the space bar.
I am using this video to (hopefully) create digital assignments for my 6th grade math students.
It helped a lot, thank you very much!
This video helped me immensely! Creating a sheet to tally attendance, wanted to have the "name" column change colors based on if the required events were attended. Used a countif in a different column to tally attendance and used your video to change the color based on that value. thanks a ton!
I've learning so much things from this short video, well done mate!
Great video thanks. Is it possible to format one cell based on anther cell equaling a DATE? Any date, i.e. if the other cell has text or formula than no format but if a date is entered then it changes color? Thanks for your consideration. ANSER FOUND: =isdate(B2) Where B2 is the cell with the referenced date
Is it possible to do this across sheets? Or use a control tab to format information?
Not sure I completely understand the question. What is it that you’re trying to accomplish?
I found this useful, may can relate: Create an Event Reminder use Color | Status: Finish; Today; Three Days Until 1 Day Before Event ua-cam.com/video/7FdByf2TEo0/v-deo.html
Can this be done to change the color of a cell based on if its value is , or = another cell? I am wanting to use the sum at the bottom of a column to compare it to a target number in another cell and each cell change based on the comparison to the other. For example if A4 is > G18 then both cells would turn red to indicate that the target number has not been reached but it would change to green when they are equal based on the sum of the column G.
I've been watching all your Google Sheet videos and they are extremely helpful. I'll be sharing them with friends and family. I think I can use this for attendance records.
Great video. would love to see a video on how to to conditional formatting based on the percentage of a number in a different cell. Example: Goal Tracker spreadsheet: Goal Sell 100 pens per week. and in subsequent cells we add weekly sales updates. Cell A1: 100, Cell B1: 90, C1: 100, D1: 75, etc. Then the conditional formatting shows a colored background based on level of success. 0% achieved, or 0 sold in this scenario is red, 100% achieved or any sales 100 or more is Green. the cells would shift from red to green as you reach your goal each tracked week.
High quality stuff here though. tag me if you create this video!
Brother I want to make a Vlookup cell copy the same fill as the cell to the left... is that possible?
You get five seconds then I'm on the next video
I have a sheet with data of 20 players where the players data is given one after the other, but separed by players in the same column and I want to highlight in different shades of green the 3 highest in investments, the 3 highest in net Value etc in Google drive, how do I do that?
Hello! I would like to highlight a cell range and remove the highlight once a text in a certain cell appears. Would it work on your sample? Appreciate your help. Thanks in advance!
I have watched a few videos on conditional formatting in hopes of what i am looking for! But I cant see to find it :(
I have a drop down menu (yes, no and pending) in column "B" and in column "A" I want it to reflect the number "0" when "No" is selected. How do I do this?! Am I researching the wrong equation? Ha! Thank you!
You are going to want to check out the if formula ua-cam.com/video/Co3aI2Jq-Yw/v-deo.html
How about if we want a row to be highlighted if a cell specific cell is populated with anything. What would be the customized formula?
Hello.
How to color the whole row if the first cell is not empty?
I don't know how to enter the formula.
Is there documentation?
Edit:
I find it:
=$A1>0
Edit2:
I think this entry is more correct
=$A1""
Is there a formula that can change the color of a row if a particular cell is blank?
Hi. New subscriber here. Im just curious if it is possible to put a automatically put the date today when I click on another cell. Because I use sheets for studying. For example I clicked A2, A1 will show the date when I last edited or click. What I do now is manually putting dates to track when I last studied a specific row. Thank you.
Easiest way to do it is to hit ctrl+shift+: I believe
Not by my PC though
That was great, thank you for this information.
Glad it was helpful!
I'm trying to track my weight. I want the conditional format to be green if the weight is less than the last recorded weight and red if more than the last date. I did it for the second weight, but when I tried to copy it down for the rest of the month it only compared every weight entered by the first weight.
How do you set it up with relative references? Alternatively, how to you copy and paste conditional formatting?
It would likely look like =If(A2
Was wondering if you had a values in column B and you had a vlookup placing values in cells column C. How can you conditionally format if B2 doesn't equal C2, and B3 doesn't equal C3. When value in rows in c doesn't match the values in Column b then I should see cells in column C highlighted. IF #NA appears in Column C that should also be considered as not matching.
Hi I am trying to to use a combination of conditional formatting and "blank" cell, but i just cannot find how to do that anywhere.
eg=NETWORKDAYS(B3,C3,Holidays!C59:C67) i have this formula to calculate how many days from one date to another, then adjacent to that column i have this formula
=NETWORKDAYS($B3,$A$1,Holidays!C60:C68) to show how many days it has been in real time.
This is where it becomes tricky, the next column i enter an end date but the clock keeps on ticking.
I want the clock to stop and the cell to go Blank, when i add the end date.
Do you have any ideas?
can any one help me on removing conditional formatting in a selected range where canditional formatting is applied/
Is it possible to also have the gmail/name of the person populate when they click a checkbox?
Great video! Thank You. I would like to change the text in one cell based on the value in another cell. For example, I have used the formula =IF(E6
Great suggestion!
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?
How can I conditionally format a cell based on whether or not it is < than or = to the average of a range of cells?
Thank You So Much! 😁
can "true" or "false" condition change to any date? i mean the cell turn yellow when u put any date.
Solved my issue. Thanks
Thank you for the explanation.
But it doesn't solve my problem. I'm using Google sheets for excercises accounting for my high school students. In stead of having to correct each excercise manually, I want to use a kind of autocorrection. I want to complete each excercise with a sheet in which I can copy the correct solution. When this is done, cells in the solution of the students which aren't correct, should light up in red.
But is more complex than that. In accountancy it doesn't matter if A proceeds B: when B proceeds A the solution can also be correct. But in my solution I might have A proceeds B and the student can have B proceeds A. In that case the cells would lighten up red, while the students solution is still correct.
Can you help me out?
I think you need to use a combination of an if statement and then combine that with conditional formatting. I’d check out my if video.
@@whyworksmarternotharder Thank you
Just tried following your steps and it's still not working on my end. Not sure if I'm doing something wrong. I'm trying to have a cell highlight a specific color when the next cell over has text inputted in. For example, I'm trying to highlight cell G23 in green when cell H23 has the word "Yes" inputted in. Any help will be appreciated. Great work with the video. I just subscribed!
Sorry for the delay. Ensure you have the dollar sign in the right spot. Watch again at the 3:00 mark
Thanks! That helped a lot!
Welcome. Thank you for commenting!
I am learning Google Sheets/Excel for a variety of uses for research and data management uses for private investigation work. I use a mobile device for most of my work so it's extra tricky
on my google sheets i don't know how this happing: row6 and 7 color keep changing to white i change back to black and if you go to next column it again writing white: is there any solution PLEASE
Excellent video. I am trying to highlight a cell when someone makes a change. I am sending a sheet to about 8 people for their updates and I want to track them. Is there a way to use conditional formatting to color a cell when it is changed?
Thanks! I'm setting up a project tracker for developing a video game.
Thank you!!!
Nice Video
I am constantly trying to turn a value red if another value equals something. Like if I used a credit card in my budget I want the amount I spent to show up red. I'm loving your videos, so easy to go down the rabit hole. . . I think I'm about 5 videos away from where I started with one of the budget videos.
When a date is input into a cell, Iwould like to use conditional formating to change the colour of another cell within a calender so that it highlighted. Any help/advice would be welcomed.
Thanks
ua-cam.com/video/H1bEpd-i4DM/v-deo.html
@@whyworksmarternotharder Thanks very much. I'll have a look at it now.
Super
@@whyworksmarternotharder Thanks for the video but its not quiet what Im after.
I have a calender which extends over a 5yr period. I would like the calender to be dynamic in that I have a series of dates (associated to tasks) which when input into an adjacent colum I would like the cell in the calender of that date to be highlighted.
Any ideas how I could so this?
how can i copy characters from a cell to another cell as a result of a check list ?
\
G, great video
Hi! You helped me a lot, but I have a question. You said in your formula that the name would become red if no text was in certain cell, which was translated as "=C4="" (the quote marks empty because cell is blank) but what happens if I want it to change the name to green by adding any text? What do you need to include in the formula between the quote marks to indicate that any text written in there will affect the other cell's color?
I don't know if I explained myself properly.
You described it correctly.
I'm looking for exactly the same.
ua-cam.com/video/xqhqtxAWjgo/v-deo.html&lc=Ugyj_I1LzX-DO-A_agd4AaABAg
Edit:
I find it:
=$A1>0
Edit2:
I think this entry is more correct
=$A1""
awesome, tutorial
Hi.. liked yr video & you hv great explanation skills. Bravo!
I hv a specific question.. pls if you can resolve for me..
There is set a transactions on my googlesheet and need to highlight the rows which have Unpaid Bills. The particular Cell (Payment value Cell) has three scenarios:
1. Empty - bill unpaid - the entire row to be highlighted in Red
2. Payment value Cell - Value is equal to Invoice value (This value is already in next Cell - same row) then No colour - non highlighted.
3. Part payment - if Cell Payment Cell is less than Invoice value - then entire row must be highlighted in Yellow.
Hope you got it.
Thks!
How do you highlight a cell if another cell does not have the data you typed/chose?
Not sure I understand your question. Can you give an example or explain further?
Do you know of any way to determine the VALUE of one cell based on the color of a different cell?
How do I turn a cell the same color as another cell just based on the fill color of the reference cell, NOT the value inside the cell?
i need to change color based on another cell if is not empty
I want to conditionally format a cell become a certain color when a currency value is added to another cell in the same row
Trying to have more than one condition to drive COLOUR coding per row
trying to figure out how to use condtional fromattin gwith a drop down
I followed the steps meticulously, but even with the dollar sign in the formula and the rule at the top of the list, the row is not changing color! Help!
If you paste your formula, I might be able to help
Thanks
You are welcome !
I want to conditional format text populating based off Yes or No dropdowns. No luck so far
Setting up a fantasy hockey sheet and trying to make a group of cells to turn red if a teams budget in a certain department ($10,000,000)
For some reason there's 3 cells that just won't change color like they should. Just a glitch, or am I doing something wrong?
Formula I used was...
=G153
I used this to better format my grades
Statement spread sheet. If balance is positive positive State: "Balance on account". If balance is negative State: "Balance due".
Good videos and thank you for your content. But, what's with the intro music always being 3 times the volume, I have to turn you up to hear you and then I worry my speakers are going to blow when your intro music plays.
thanks
I want a cell to change color if a different cell has content in it
Yes this video should cover that.
Do you have Facebook so I can send what I’m looking for to do
facebook.com/groups/344454936502236/?ref=share
I'm needing to change colour of number based on value of cell above. IE number in A3 is lower than A2 (make red) if higher turn blue.
Its easy in excel, but Sheets has me stumped. 😅
COOL
Awesome!!
didnt work for me :(
GG BRO
Video once a week but you only have 30 videos :(
Thank you!