Prev: Alert Message After Somthing Changed
Next: to lookup data for 'today()'
From: Esradekan on 30 Mar 2010 04:03
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
From: Mike H on 30 Mar 2010 04:49
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
> .
>
From: Esradekan on 31 Mar 2010 19:37
On Mar 30, 9:03 pm, Esradekan <esrade...(a)gmail.com> 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
From: Gord Dibben on 1 Apr 2010 11:16
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 <esradekan(a)gmail.com>
wrote:

>On Mar 30, 9:03�pm, Esradekan <esrade...(a)gmail.com> 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

From: Esradekan on 1 Apr 2010 20:52
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 <esrade...(a)gmail.com>
> wrote:
>
>
>
> >On Mar 30, 9:03 pm, Esradekan <esrade...(a)gmail.com> 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
>(*-*)<
 |  Next  |  Last
Pages: 1 2
Prev: Alert Message After Somthing Changed
Next: to lookup data for 'today()'