Hi,
I need help creating a VBA script to change the fill color of part of a row based on selecting 1 of 5 options from a dropdown list.
Here how my worksheet goes. Column J contains a dropdown menu with 5 options (SAVE, LOSS, PENDING, NON RET, DUPL CALL). What i want to happen is when any of the 5 options a chosen, the fill color for that row from column B to K to change.
For example, cell J5 is changed to "SAVE" and from B5 to K5 the fill color becomes Yellow.
I've looked at other similar post but none of them deal with filling a part of row, only single cells.
I'm completely new to VBA scripts so i don't know where to start.
Thank you
Danny
Bookmarks