Great!!!! Thanks so much - very helpful

Awesome. Now I know how to change cell color. Thank you. But how do I change color of not just one cell, but all cells to the right from it, lets say 20. If A1 has employee name and micro change color of A1 to red, how change all B1 to Z1. So I need entire row to change color, but only based of value on A1. Thank you.

This is great. It would be a bless if you could provide a VBA on how to change a cell interior based on a specific text in a cell, not cell value.

Thanks a lot sir, very very usefull.

Very helpful, thanks!

Thank you very much!! Best video about this I've seen

Not quite what I was looking for, but handy.

Hello, thank you for this video. I was able to easily implement. Would you be able to tell me how to implement this code based on two cells being true, meaning, if A1=Strawberry and B1= Blueberry, then range A1:B1 has a interior color of red? Much Appreciated

which code did you use to insert the cells accordingly, like the west, north etc

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?

Thanks for the sharing

I have one question, in the value where you mention specific value then can we select their range as well.

Do you have a macro code that will use the specific text inside a cell? That specific text will change everyday so I need something that will use what's inside the cell as a basis because it changes everyday.

Thank you ver much for video. how can get backgorund color automaticly from list? I mean (in your example ) if cell's value NORTH , search it on range (I:j) and get the backgorun color from range. value is NORTH will be red background color etc...

Thanks a lot..

Biggest problem in this approach that it is not efficient for large tables as the sub is re-evaluated for the entire table after any individual change is made, especially if you copy paste... Is there anyway the same results could be achieved without a global re-evaluation? only evaluate whatever is changed in the step

Hi is it possible if I selected a random range and apply the condition? I can only do the setted range but not the selected selection.

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 a monthly 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.

is it possible to select a single text value and change the whole row colour. E.g. if East was the only word in the row and you want to highlight that whole row is that possible. May select from a drop down list and that will change the whole row colour. Like using conditional formatting formula

I learned much from your presentation. I am trying to apply this to a sheet I am building. The only thing that is different is it is a table. I can not get it to work correctly. I think the issue is in the line set. What needs to be different to use this with a table?

Case statements can also be used.

Is their a way to also change the text color based on the cell color? So if East, it is blue box and white text? Thanks!

I want to change the color of a cell for creating a call contact log. Green for "Made contact", Yellow for "No answer" and Red for "Phone number is not good". How can I do this? And I enjoyed your video!!

Good learning

Good thing

Sir I'm getting this error Private sub worksheet_selectionchange(Byval Target As Range) is coming in yellow highlight After completing all code processes

what does "next" do at the end please?

How to make this dynamic?

Hello Sir, you have not defined cell as a variable but in my program which also consists of your following codes is giving me an error for variable not defined. Can you please tell me what it can be??

i was expecting the "macro code file" in the Description :-(

How to go to VBA page?

a) bad that it's not a vlookup b) bad that you didn't show actually running the macro but spent 10 minutes formatting c) bad you squeezed 2 adverts into that short video d) bad it didn't work for me e) the comments saying this video is good are wrong

can't understand a word... so I've muted it... we'll see..

Vba code doesn't work. Tutor didn't even bother to run the code to check any errors... Pathetic..