Trying to change, then change back could be a bit of a pain, it would be easy enough with no existing fill colours, but trying to get the colour pre change, then reverting it back after will be an absolute nightmare. You could combine conditional formatting with vba to make it work, but that would be extremely slow and inefficient.
As an alternative, see if this works well enough for what you need. I've taken bits from both previous suggestions and mashed them together. This will scroll to the column, the same as Melvosh's code did previously, if you want it without that then simply delete the line in red.
Bookmarks