cell vlue based on cell back colour

[Esradekan]

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

 

[Mike H]

Hi,

Is there a simple formula that will allow me to do this?

There may be.

How are the colours derived is it conditional formatting or simply fill? If
it's the former Post the CF formula(s)

What is the algorithm for deciding what colour a cell will be?
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[Esradekan]

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

 

[Gord Dibben]

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

 

[Esradekan]

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





- Show quoted text -

HI,

Yes they are the result of conditional formatting and all I want if
they are green to show a number 1 in the adjoining cell in the B
column and if they are red, a number 1 in the C column.

I am trialling the beta version of office 2010 at the moment but
normally use 2007.

TIA
Esra

 

[Gord Dibben]

You have conditions in column A that color the cells.

Use those conditions in B and C

B1 formula =IF(A1=greencondition,1,"")

C1 formula =IF(A1=redcondition,1,"")


Gord

 

[Esradekan]

You have conditions in column A that color the cells.

Use those conditions in B and C

B1 formula   =IF(A1=greencondition,1,"")

C1 formula   =IF(A1=redcondition,1,"")

Gord




- Show quoted text -

Doesnt work. Comes up with #NAME?

Any idea of the problem?

Esra
TIA

 

[David Biddulph]

Did you try to use the words greencondition and redcondition instead of
actually inserting the relevant conditions? If so, you will get #NAME? if
you haven't defined greencondition and redcondition.