Are the colored cells in A1:A35 the result of Conditional Formatting?

Are they manually colored?

What numbers do you want in column B based on colors in column A?


Gord Dibben MS Excel MVP

On Wed, 31 Mar 2010 16:37:52 -0700 (PDT), Esradekan
wrote:

On Mar 30, 9:03*pm, Esradekan wrote:
Cell Range A1:A35 are different colours (Red, Green, Blue - depending
on their value)
I want B1:B35 to show a number, based on the colour of adjoining
cells.
Is there a simple formula that will allow me to do this?

TIA (*-*)<
Esra

Nobody able to give me an answer?

Esra