Using If then statement to change cell fill color (sort of) 

Thank you very much. Your's is the 4th video a watched on this topic and the only one who was able to help me.

Like everyone on here has already said....EXACTLY what I was looking for. Thank you so much

Very Helpful. Been trying to work that out for a few hours!

We can also put the color on the corresponding "Attending Party" cell.. isn't it? maybe saving a column for large worsheet..

congrats,YOU ARE PROGRAMMING!!

Thank you!!! This was exactly the video I needed to help me make mystery pixel art worksheets for my students. All the other videos I could find for the pixel art was in Google Sheets. You are a lifesaver!

It's good lesson but how can those colors replacement the words or grade for example where we have the marks 10 we need green color but number 10 no display how can I do?

you are the angle in my nightmare. you saved me!

EXACTLY what I was looking for. Thanks buddy

This does NOT answer the question of how to use IF to change cell color. This is simple formatting based on one cell value but I need to evaluate multiple columns to set the color so basically a nested IF statement or equivalent.

This is what I was looking for. Thank you very much!!

Thank You, That is what i was looking for.

thanks a lot sir, even i checked in my many Indian languages.. n many ways but finally i got it from you.. thanks a lot.. n subscribed with respect 🙏🙏🙏

Great video clear instruction and simple execution. Thank you

EXACTLY what I was looking for, THANK YOU THANK YOU, Brian!

Excellent, thanks for this video. I needed this.

Thank you very much Mr.Brian. I was interested to learn this.

This is just what i was looking for. thanks for sharing

Thank you sir! i was looking for this

Mate you are a legend thank you so much for this!

This video was beyond helpful! Just wondering if it's possible to have the whole row be colored with a condition? I have cell that says either Yes or No, and I want the whole row to be colored red for no and green for yes. I know how to do it for one row, but can't figure out how to do this command for multiple rows. I can get the yes and no cells to change color exactly like in this video, but the rest of the row doesn't respond. Do I really have to do this rule for every row?

exactly what i was looking for

OK, but you could just place the conditional formatting to the same cell as the response cell instead of creating a whole new column just for the color! That way the cell that says "Maybe" will become yellow itself, etc...

Superb video it saved my bacon clearly shown absolutely brilliant

Thanks Brian! Exactly what I was looking for! Thumbs up!

Thank you ... I'm searching this for long time.🤓

Great video but why do I have a problem if I perform the exact same method Vertical instead of Horizontal like you showed.

THIS IS SO HELP FULL. I KEEP FORGETTING THIS TECHNIQUE BETTER SUBSCRIBE.

Thank You very much. This was very helpful

Thank you sir for nice and clear video, I have a question pleas. I make a table that contains in culomn A doctors names and the headers in row1 is the month date. Inside the table all the cells has data validation with departments in hospital to make rota shift for the doctors. The list of the data valedation contains (main department, long shift, short shift, emergency, operation room, DAY OFF). I want to make a conditional FORMATING THAT IF I CHOOSE "long shift" from the data validation automatically gives this doctor "DAY OFF" for the next day and color the cell of "DAY OFF" in red. How can I do that.( For example if I choose in C5 "long shift" automatically mak D5 "DAY OFF" with red background in B5.) thank you.

thank you, i can use it in our examination result preparations for our school.

I was looking for it thanks 🙏

Just the tutorial I was looking for thank you so much for this video:) But I have one simple question, exactly at 1min 57secs of your video you said "we want it to cascade down and to get rid of the lock which it defaults to" so my question is how do I do that because the formula is only working for the cell at the top example (B18) and ignores all the rest underneath?

Good information However this only work in some of the cells.

Good video. Very informational. Thanks.

exactly what i was looking for. thanks a lot Man!!

thanks so much! Finally found a video after trying for an hour!

It would have been helpful if we could have done it through nested if anywasy ur tutorial was very helpful

Thanks. But how was the for number like 0-10

Hi, your video was useful. When I tried to do as you did, it's not working for me. =E2="FALSE" Anything wrong with formula?

Thanks for sharing, God bless....

Hi there, Nice video. Can you achieve this same effect by having it fill multiple fields in color?

Perfect just what I was looking for but I am putting a letter in the cell and having it change colour for a spreadsheet who is or who is not at work.

How can apply this rule in multiple tables in same and different sheets? Thanks in advance

Oh MAn , you re so awesome, thank you so much!!!

Informative, thank you

It doesn't color my cells and just leave them as they are. I am following your examples to the letter. What am I doing wrong?

awesome video but when i save it, and re open it colours dissapear

Not sure what I am doing wrong :/ When I enter the formula for my first criteria it turns all of the cells the same color regardless of the data in the cell?

can we do vice versa, if the cell color is red then the text is MAy be or yes etc

Great explanation, thank you

This is really helpful. But I just wanna ask, what if you have two statements to satisfy to make it change the color? Such as in a table of numbers for example, you need to determine a number by its row and column. Thanks a lot for this.

Hi Brian, based on the value if I want to change cell colour in different sheet then how to do it???

When selecting the box how do u casket or take the lock off on the second Page help please

Really good video. Could you tel me how this would work for numerical data - say you needed a different colour for a cell/row of cells based on the value for a given cell... 200-299 (one colour), 300-399 (another colour)..and so on?

how to change the text automatically based on the value in another cell..?

So useful - Thank you!

Thanks, you're an angel!

Thankyou very much this was really helpful

Thank Bro it's very helpful video

Thank you! $ was the only issue.

Thank you , very useful

I consider myself an advanced / expert user on excel and was doing this correctly, but couldn’t work out why it wasn’t working. I didn’t realise the $ locks cells 😂 learn something new everyday

Please do you know how to formulate the following condition in excel; when you have two cells one with high and the other with low value and one of the cell is colored green. so you want to return a value of '1' if the lowest value among the two cell is green color and '0' is the highest value among the cell is green. is there a condition or formula for the statement in excel

if we have more than one word ?

Hello, is there a way to do this in only one step instead of 3??

Thanks a lot Buddy 👍

Do you know how to do this for a date range greater than the cell chosen. For example, If I want all cells greater than 11/8/2018 to show as green, could I use the same concept?

How can apply this to different colossus- for example: if column A, B, C = text, then color another column (cell) ??????????

Not worked for marking number like red for 0 and green for amounts

How do you generalize the rule to include/color other columns (eg: D,E,F,G ...)?

can you combine the colour and attending party together. instead of three column, just 2, and showing yes with green together? thanks for the video

I wanted to have the cell change colour every day. Fir example today blue, tomorrow green and next day different colour and so. Without having a date put in any column. Is this doable?

hi, i noted a few weights down in kg and want to highlight another cell called ''current'' in red or green, if the value i put in there matches or is higher or lower than the weights (sort of counting the accomplishments). do you know how to do this?

How if E column input number color is red then A column input number and B column input text color also will be red ?

This doesn't work when my data is coming from data validation. If you can please help?

Sir before and after yes which sing you put ?

Thank you sir!

how can i list the cells which is marked with the specific colors in the same excel separately?

This helped. Thank you.

hai you are teaching very useful video sir thanking you sir you are more downloading sent RU-vid

thank you very much. You just short my day :d.

Is it possible in google sheets with their to-do list, when the task is completed the header color changes to easily identify completed tasks? Thanks.

Can v apply change in colour in the same coloumn? If so can u elobrate it

Thnx, lot u r great, I have desire to know if possible u teach us how v can scanning barcode with color by double scanning ,thnx

Thank you so much. Already liked and subscribed.

Thank you so much! :)

Does this work if the "color" column has numbers in it? example: I want D3 which is red and says Amanda to populate F3 which has a $amount to also be red, and then I have yellow Martina's and Green Hollys in the D column also. I want whatever color is in the cell of the D column to change the color of the cell in the F column. I've been trying all morning and cant get this to work . HELPPP pretty please

Hi, I'm having trouble finding it on google: what's the rule for this but the trigger being another cell being blank vs unblank. I'm doing room checks and have a comments cell for each room where I list any errors. I want the room number cell to turn red if there's any errors written down, so I guess =d1="literallyanytextaha,what'sthelineforthat" thanks!

Is there a way to change the cell colour whenever any data is entered in a cell regardless of what you enter?

This was perfect. Thanks.

Thank you!

How fill color in number? Eg. +10, -10, +20, -20

what if I need the cell to change color upon any input I right in the other cell not just "Yes" or "No" I mean if I wrote a date or a text or any info, IS it possible?

HEY! does anyone know how can i apply the same formula into the rows below??? i cant!!!

what if the highlighted parts are needed to customized color? it still the same, or different rules?

Thank you so much

i have not gettting this option in new formula how to do fix it give me solucation

how do you get rid of the lock?

Where exactly did you use if then statement?