Thank you very much for this! It now works like a dream. For some reason when I sed the preset rule options on the "conditional formatting2 it was just not as effective as creating a new rule. Now it is fine!

I got confused with my formula, I though it would have to be more complex to apply to a range and change every time.

Thanks for all your help!

---------- Post added at 03:17 PM ---------- Previous post was at 03:16 PM ----------

Thank you very much for this! It now works like a dream. For some reason when I sed the preset rule options on the "conditional formatting2 it was just not as effective as creating a new rule. Now it is fine!

I got confused with my formula, I though it would have to be more complex to apply to a range and change every time.

Thanks for all your help!