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,