Conditional Formatting in Excel VBA is very easy and powerful. You can use simple VBA Code with For Loop and If Condition on Worksheet Event to experience Conditional Formatting in Excel with VBA Macro.
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.
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?
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
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.
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
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
Sir I'm getting this error Private sub worksheet_selectionchange(Byval Target As Range) is coming in yellow highlight After completing all code processes
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!!
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...
I can give you the logic. You should use looping statement to look for the selected value and then use the matching color for background. We are a freelancing team. If you need any of the VBA Code for your project. Please let us know.
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.
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 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?
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