Hi all,
I need help with either vba code or formula.
I have a data validation drop down list which contains numbers 1-45.
I am able to select multiple numbers from the drop down list at once.
Look at the middle column. Below RUN No is my drop list. Below this are columns with various numbers and letters. The numbers I am interested in are the black font size 18 (23 for example).
When I select 23 from my drop list I want excel to do the following things.
1. create a border containing the cell with 23 in, the cell to the left, and the block of 4 cells below ending up with a block of cells 2 x 3 inside a border.
2. highlight the cells within the border.
3. it is very important that the selected cells remain like this when other cells are being selected.
Can anyone help me and point me in the right direction.
many thanks
Lee
