Hi,

Is there a way (what formula) to reference a range of cells based on the
color or not blank, then return the number on a separate cell? Example
ColumnB C
1000 1001 1002 1003 1004
Model 200 100 300 200 200
Row 10 Yellow
Row 11 Blue
Row 12 Green
Row 13 Yellow
Row 14 Yellow

where 100=Blue, 200=Yellow, 300=Green
The formula needed is in starting row 9, column B (result=200)

See:

http://www.cpearson.com/excel/Colors.aspx
--
Gary''s Student - gsnu200798


"Cam" wrote:

Hi,

Is there a way (what formula) to reference a range of cells based on the
color or not blank, then return the number on a separate cell? Example
ColumnB C
1000 1001 1002 1003 1004
Model 200 100 300 200 200
Row 10 Yellow
Row 11 Blue
Row 12 Green
Row 13 Yellow
Row 14 Yellow

where 100=Blue, 200=Yellow, 300=Green
The formula needed is in starting row 9, column B (result=200)