Hi, MiloG,

you should attach a sample workbook to have a look at how the data in the range is changed (Formula or Values) and how the colour is applied (by hand or by use of Conditional Formatting).

Ciao,
Holger