Conditional Formatting on Form - Over 3 Custom Formats
$20-25 USD
Completed
Posted over 14 years ago
$20-25 USD
Paid on delivery
Hi all,
I have a form and in that form is a column that I need to change colors based on what is typed into it. I have used the user interface but I have more than 3 conditional formats so everything I read says to use VBA and to put some code in the "onupdate" but I can not find any such thing.
So what I need is for someone to write detailed instructions on how to implement more then 3 conditional formats VIA VBA so that I can go ahead and make the changes. Even better would be if you can explain how to change the background colors of the entire rows based on what is inputed into the first box.
I have attached the form. You will notice a column that says "Section points to"? Based on what is entered into there I need the background to change color. So if apple is entered the row turns red, if orange is entered background turns orange, etc.