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