S
Steve
hi all,
new to VBA - any help greatly appreciated
I have searched high and low, possibly not asking the right questions
however
each cell in my range (D3:AH17) has a Data Validation drop down box. The
dropdown is the same in every cell and contains seven values, SL, RL, RDO,
TD, PH, SPL, SL (refering to types of leave etc)
I need to conditional format the cell (change the interior colour) depending
on what the user selects from the dropdown, or leave the interior colour as
default if the cell remains empty. I have more than 3 criteria and hence
need some VBA code...
Im guessing a ThisWorkbook Change event? but im only guessing!! can someone
help me out?
regards
steve
new to VBA - any help greatly appreciated
I have searched high and low, possibly not asking the right questions
however
each cell in my range (D3:AH17) has a Data Validation drop down box. The
dropdown is the same in every cell and contains seven values, SL, RL, RDO,
TD, PH, SPL, SL (refering to types of leave etc)
I need to conditional format the cell (change the interior colour) depending
on what the user selects from the dropdown, or leave the interior colour as
default if the cell remains empty. I have more than 3 criteria and hence
need some VBA code...
Im guessing a ThisWorkbook Change event? but im only guessing!! can someone
help me out?
regards
steve