Hi Andy,

on the variable Z2 (color) of the file (750713b.xls) I have created on the range (F2: F51) 40 random numbers between 1 and 20.
On this range I have applied the rule of conditional formatting of two colors (max=red and min = blue).
This is my question: Is it possibile, creating a new Sub, to transfer to the 5 forms the color corresponding to the cells included in the range F2: F51?

bye

Antonino