cell vlue based on cell back colour
 

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

cell vlue based on cell back colour
 

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" 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
.

cell vlue based on cell back colour
 

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

cell vlue based on cell back colour
 

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

cell vlue based on cell back colour
 

On Apr 2, 4:16*am, Gord Dibben <gorddibbATshawDOTca wrote:
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- Hide quoted text -

- 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
(*-*)<

cell vlue based on cell back colour
 

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

On Thu, 1 Apr 2010 17:52:29 -0700 (PDT), Esradekan
wrote:

On Apr 2, 4:16*am, Gord Dibben <gorddibbATshawDOTca wrote:
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- Hide quoted text -

- 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
(*-*)<

cell vlue based on cell back colour
 

On Apr 3, 3:30*am, Gord Dibben <gorddibbATshawDOTca wrote:
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

On Thu, 1 Apr 2010 17:52:29 -0700 (PDT), Esradekan
wrote:



On Apr 2, 4:16*am, Gord Dibben <gorddibbATshawDOTca wrote:
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- Hide quoted text -

- 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
(*-*)<- Hide quoted text -

- Show quoted text -

Doesnt work. Comes up with #NAME?

Any idea of the problem?

Esra
TIA
(*-*)<

cell vlue based on cell back colour
 

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.
--
David Biddulph


"Esradekan" wrote in message
...

Doesnt work. Comes up with #NAME?

Any idea of the problem?

Esra
TIA

On Apr 3, 3:30 am, Gord Dibben <gorddibbATshawDOTca wrote:
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

On Thu, 1 Apr 2010 17:52:29 -0700 (PDT), Esradekan
wrote:



On Apr 2, 4:16 am, Gord Dibben <gorddibbATshawDOTca wrote:
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- Hide quoted text -

- 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
(*-*)<- Hide quoted text -

- Show quoted text -