You need VBA Ray.

--
HTH

Bob Phillips

"ray_costa" wrote in message
...
Coul you tell me any method beside macro if I want the cell A2 to return
any
number or text if cell A1 is filled with colour.

Thx for any help

Ray