Ok your correct it works. I was having issues due to the single quote still being in the formula ( which you are correct it is no longer required). I knew formulas auto adjusted within the sheet but never realised conditional formating did the same. Thanks for all your help and how to i list thread as sovled?