Hi there
I am trying to find a resolution in light of my organisation disabling VBA macros and wont allow me the unblock feature so causing a few operational issues and a real pain.
In this case I have a range of cells from c13 to c200 with employee numbers. I am wanting to be able to click on any one of these cells and have the background color and font to change to help user identify number clearer.
Is this possible without VBA. I have tried a helper col in B to try and enter a 1 indicator but cant get that to work either.
Any help would be appreciated and I am sure quite a few users will be frustrated with having macros disabled if organisation policy
regards
Ian
I am trying to find a resolution in light of my organisation disabling VBA macros and wont allow me the unblock feature so causing a few operational issues and a real pain.
In this case I have a range of cells from c13 to c200 with employee numbers. I am wanting to be able to click on any one of these cells and have the background color and font to change to help user identify number clearer.
Is this possible without VBA. I have tried a helper col in B to try and enter a 1 indicator but cant get that to work either.
Any help would be appreciated and I am sure quite a few users will be frustrated with having macros disabled if organisation policy
regards
Ian