Conditional Format help please

[chef]

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

 

[6StringJazzer]

One last thing: You could use my conditional formatting rule without VBA but you would have to hit F9 to update the highlighting.

 

[Peter_SSs]

I would make the modest suggestion that a link to the rules could be added in the navigation such that you can get to the rules from the top menus of any page.

I will pass the suggestion on for consideration.

 

[chef]

thank you for all your help and sorry if I caused any agnst.
I guess my biggest bugbear is having macros disabled as files are already on a secure network with controlled access. Progress huh

 

[Peter_SSs]

sorry if I caused any agnst.

You have nothing to apologise for.

I guess my biggest bugbear is having macros disabled ...

I can understand that but not much we can do about it of course.

I will pass the suggestion on for consideration.

Not sure if you had noticed, but it has been implemented. It is available under the Forums menu.

If you have scrolled down the page then use the drop-down arrow that then appears next to 'Forums'

Thanks for the suggestion.

 

[6StringJazzer]

Wow, that is a pleasant surprise. On another Excel forum that I won't name , when I make a suggestion they begin ignoring it immediately

 

[Peter_SSs]

Wow, that is a pleasant surprise.

You have nothing to apologise for.

Actually I should be apologising as I have allowed your thread to be hijacked somewhat with issues unrelated to your thread. I think that has finished now though.