Hey, Sunny. That was spot one. Your code is awesome and does exactly what I need. Many thanks 🙂 Nik
Hi Sunny Thank you for responding and providing the additional information. Apologies, I didn't explain myself well, but as per the example data I ...
Just in case someone else needs something similar, I have a solution... Inserting a helper column B then copy down the following formula "=IF(...
Thanks, Sunny. But your solution doesn't do what I need. I already have the data in a spreadsheet. What I need is to retrospectively apply 2 colours ...
Thanks, Franz. I have probably not explained myself very well. I have attached an example... So where the reference changes in column A I'd l...
Hi SunnyKow Thanks for responding. I have pasted my data into sheet 1 but nothing has happened to change the colours. There is code in S...