Prev: Alert Message After Somthing Changed
Next: to lookup data for 'today()'
From: Gord Dibben on 2 Apr 2010 10:30
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 <esradekan(a)gmail.com>
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 <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
>>(*-*)<

From: Esradekan on 3 Apr 2010 06:00
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 <esrade...(a)gmail.com>
> 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 <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
> >>(*-*)<- Hide quoted text -
>
> - Show quoted text -

Doesnt work. Comes up with #NAME?

Any idea of the problem?

Esra
TIA
>(*-*)<
From: "David Biddulph" groups [at] on 3 Apr 2010 12:49
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" <esradekan(a)gmail.com> wrote in message
news:ae7a6e64-cc2a-4c93-a916-647b44af4bd2(a)z4g2000yqa.googlegroups.com...

> 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 <esrade...(a)gmail.com>
>> 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
>> >> <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
>> >>(*-*)<- Hide quoted text -
>>
>> - Show quoted text -



First  |  Prev  | 
Pages: 1 2
Prev: Alert Message After Somthing Changed
Next: to lookup data for 'today()'