Hi

I have a workbook with several sheets
The first sheet contains a list of participants for a rugby survey
Column A is ID e.g. RG_1, RG_2, RG_3 etc.
As the survey results come in I am colour-coding Column A
green - survey completed, red - email bounced, etc

The remaining sheets show subsets of sheet1 broken down into decades

How do I reference a cell in column A sheet 1 and get both its value and colour?

Thanks



Bob M