Hi,

This is just a quick "can it be done" question.

Is it possible to reference a cell's colour in a formula within a spreadsheet - without using VBA?

i.e If Cell A1 has a fill colour of yellow, can I have a formula in cell A2 that says

If Cell A1 fill colour = Yellow, result = 1 etc.

I know this can be done in VBA, and I have done that, but just wondered if possible this way.

Thanks & regards,

Dave

This is just a quick "can it be done" question.

Is it possible to reference a cell's colour in a formula within a spreadsheet - without using VBA?

i.e If Cell A1 has a fill colour of yellow, can I have a formula in cell A2 that says

If Cell A1 fill colour = Yellow, result = 1 etc.

I know this can be done in VBA, and I have done that, but just wondered if possible this way.

Thanks & regards,

Dave

## Comment