test.xlsm
I have a drop down list (data validation) for every cell in my range I18:I190 with these 8 options
Quoted
Bound
NTU
WIP
Modelling
Declined
Non-Renewed
Extended
I want the range J18:J190 to be populated with text based on these statements:
If I18="Bound" then J18="Green",
If I18="NTU","Declined" or "Non Renewed" then J18="Red", otherwise do nothing.
I want the macro to be run whenever there is a change to the I18:I190 range, and this should work for all worksheets in the workbook if possible.
thanks!
Bookmarks