I have 2 columns of data.
If the number in b1 is less than a1, I want the number in b1 to be displayed
in pink.
How do I do this?
Many thanks for any help!

Yoe are welcome! Thanks for the feedback!
Stefi


„Minâ€� ezt Ã*rta:

> Many thanks! Easy when you know how!
>
>
> "Stefi" wrote:
>
> > Select column B
> > Formats/Conditional formatting
> > Choose formula as criterium
> > Formula: =B1<A1 set format/pattern/choose pink
> >
> > Regards,
> > Stefi
> >
> >
> > „Minâ€� ezt Ã*rta:
> >
> > > I have 2 columns of data.
> > > If the number in b1 is less than a1, I want the number in b1 to be displayed
> > > in pink.
> > > How do I do this?
> > > Many thanks for any help!

Hi,

For more information on Conditional Formatting, refer to this link:
http://office.microsoft.com/en-us/ex...CL100570551033

Challa Prabhu

"Min" wrote:

> I have 2 columns of data.
> If the number in b1 is less than a1, I want the number in b1 to be displayed
> in pink.
> How do I do this?
> Many thanks for any help!

I have a similar question, only my problem is i want to evaluate A1 on tab1,
vs A1 on tab2, and apply a color pattern if A1 on tab1 ABS<1 and A1 on tab2
ABS>1. How can I do this, as conditional formatting does not allow other
tabs or files?

Thanks
Mike

"Stefi" wrote:

> Select column B
> Formats/Conditional formatting
> Choose formula as criterium
> Formula: =B1<A1 set format/pattern/choose pink
>
> Regards,
> Stefi
>
>
> „Minâ€� ezt Ã*rta:
>
> > I have 2 columns of data.
> > If the number in b1 is less than a1, I want the number in b1 to be displayed
> > in pink.
> > How do I do this?
> > Many thanks for any help!

You need to specify the Sheet name in addition to the cell if it is not
on the same sheet eg Sheet2!A1

mturboman wrote:

> I have a similar question, only my problem is i want to evaluate A1 on tab1,
> vs A1 on tab2, and apply a color pattern if A1 on tab1 ABS<1 and A1 on tab2
> ABS>1. How can I do this, as conditional formatting does not allow other
> tabs or files?
>
> Thanks
> Mike
>
> "Stefi" wrote:
>
>
>>Select column B
>>Formats/Conditional formatting
>>Choose formula as criterium
>>Formula: =B1<A1 set format/pattern/choose pink
>>
>>Regards,
>>Stefi
>>
>>
>>„Minâ€� ezt Ã*rta:
>>
>>
>>>I have 2 columns of data.
>>>If the number in b1 is less than a1, I want the number in b1 to be displayed
>>>in pink.
>>>How do I do this?
>>>Many thanks for any help!

You can refer to another sheet for CF only if you define a name for cell on
other sheet.

i.e. defined name "apple" refers to =Sheet2!A1

Example........On Sheet1 in A1 CF>Formula is: =A1<ABS(apple)


Gord Dibben MS Excel MVP

On Thu, 04 Feb 2010 08:20:31 -0600, Bob I <(E-Mail Removed)> wrote:

>You need to specify the Sheet name in addition to the cell if it is not
>on the same sheet eg Sheet2!A1
>
>mturboman wrote:
>
>> I have a similar question, only my problem is i want to evaluate A1 on tab1,
>> vs A1 on tab2, and apply a color pattern if A1 on tab1 ABS<1 and A1 on tab2
>> ABS>1. How can I do this, as conditional formatting does not allow other
>> tabs or files?
>>
>> Thanks
>> Mike
>>
>> "Stefi" wrote:
>>
>>
>>>Select column B
>>>Formats/Conditional formatting
>>>Choose formula as criterium
>>>Formula: =B1<A1 set format/pattern/choose pink
>>>
>>>Regards,
>>>Stefi
>>>
>>>
>>>„Minâ€? ezt Ã*rta:
>>>
>>>
>>>>I have 2 columns of data.
>>>>If the number in b1 is less than a1, I want the number in b1 to be displayed
>>>>in pink.
>>>>How do I do this?
>>>>Many thanks for any help!

My bad, thanks!

Gord Dibben wrote:

> You can refer to another sheet for CF only if you define a name for cell on
> other sheet.
>
> i.e. defined name "apple" refers to =Sheet2!A1
>
> Example........On Sheet1 in A1 CF>Formula is: =A1<ABS(apple)
>
>
> Gord Dibben MS Excel MVP
>
> On Thu, 04 Feb 2010 08:20:31 -0600, Bob I <(E-Mail Removed)> wrote:
>
>
>>You need to specify the Sheet name in addition to the cell if it is not
>>on the same sheet eg Sheet2!A1
>>
>>mturboman wrote:
>>
>>
>>>I have a similar question, only my problem is i want to evaluate A1 ontab1,
>>>vs A1 on tab2, and apply a color pattern if A1 on tab1 ABS<1 and A1 ontab2
>>>ABS>1. How can I do this, as conditional formatting does not allow other
>>>tabs or files?
>>>
>>>Thanks
>>>Mike
>>>
>>>"Stefi" wrote:
>>>
>>>
>>>
>>>>Select column B
>>>>Formats/Conditional formatting
>>>>Choose formula as criterium
>>>>Formula: =B1<A1 set format/pattern/choose pink
>>>>
>>>>Regards,
>>>>Stefi
>>>>
>>>>
>>>>„Minâ€? ezt Ã*rta:
>>>>
>>>>
>>>>
>>>>>I have 2 columns of data.
>>>>>If the number in b1 is less than a1, I want the number in b1 to be displayed
>>>>>in pink.
>>>>>How do I do this?
>>>>>Many thanks for any help!
>
>

Thanks for the reply Gord.

I do have a question though, is there an easier or better way to accomplish
this, as I am currently looking to review about 1500 cells with this criteria
on Tab 3 and looking to Tab 1 and Tab 2 to evaluate would be a lot of named
ranges. Is there a better more efficient way that I can format the cell in
Tab 3, using data in the same cell of Tab 1 and Tab2 to evaluate the color of
the cell on Tab 3?

Thanks,
Mturboman

"Gord Dibben" wrote:

> You can refer to another sheet for CF only if you define a name for cell on
> other sheet.
>
> i.e. defined name "apple" refers to =Sheet2!A1
>
> Example........On Sheet1 in A1 CF>Formula is: =A1<ABS(apple)
>
>
> Gord Dibben MS Excel MVP
>
> On Thu, 04 Feb 2010 08:20:31 -0600, Bob I <(E-Mail Removed)> wrote:
>
> >You need to specify the Sheet name in addition to the cell if it is not
> >on the same sheet eg Sheet2!A1
> >
> >mturboman wrote:
> >
> >> I have a similar question, only my problem is i want to evaluate A1 on tab1,
> >> vs A1 on tab2, and apply a color pattern if A1 on tab1 ABS<1 and A1 on tab2
> >> ABS>1. How can I do this, as conditional formatting does not allow other
> >> tabs or files?
> >>
> >> Thanks
> >> Mike
> >>
> >> "Stefi" wrote:
> >>
> >>
> >>>Select column B
> >>>Formats/Conditional formatting
> >>>Choose formula as criterium
> >>>Formula: =B1<A1 set format/pattern/choose pink
> >>>
> >>>Regards,
> >>>Stefi
> >>>
> >>>
> >>>„Minâ€? ezt ÃÂ*rta:
> >>>
> >>>
> >>>>I have 2 columns of data.
> >>>>If the number in b1 is less than a1, I want the number in b1 to be displayed
> >>>>in pink.
> >>>>How do I do this?
> >>>>Many thanks for any help!
>
> .
>

There is no easy way to CF a cell based upon the value of a cell in another
worksheet.

Probably have to go with VBA


Gord

On Wed, 17 Feb 2010 15:24:01 -0800, mturboman
<(E-Mail Removed)> wrote:

>Thanks for the reply Gord.
>
>I do have a question though, is there an easier or better way to accomplish
>this, as I am currently looking to review about 1500 cells with this criteria
>on Tab 3 and looking to Tab 1 and Tab 2 to evaluate would be a lot of named
>ranges. Is there a better more efficient way that I can format the cell in
>Tab 3, using data in the same cell of Tab 1 and Tab2 to evaluate the color of
>the cell on Tab 3?
>
>Thanks,
>Mturboman
>
>"Gord Dibben" wrote:
>
>> You can refer to another sheet for CF only if you define a name for cell on
>> other sheet.
>>
>> i.e. defined name "apple" refers to =Sheet2!A1
>>
>> Example........On Sheet1 in A1 CF>Formula is: =A1<ABS(apple)
>>
>>
>> Gord Dibben MS Excel MVP
>>
>> On Thu, 04 Feb 2010 08:20:31 -0600, Bob I <(E-Mail Removed)> wrote:
>>
>> >You need to specify the Sheet name in addition to the cell if it is not
>> >on the same sheet eg Sheet2!A1
>> >
>> >mturboman wrote:
>> >
>> >> I have a similar question, only my problem is i want to evaluate A1 on tab1,
>> >> vs A1 on tab2, and apply a color pattern if A1 on tab1 ABS<1 and A1 on tab2
>> >> ABS>1. How can I do this, as conditional formatting does not allow other
>> >> tabs or files?
>> >>
>> >> Thanks
>> >> Mike
>> >>
>> >> "Stefi" wrote:
>> >>
>> >>
>> >>>Select column B
>> >>>Formats/Conditional formatting
>> >>>Choose formula as criterium
>> >>>Formula: =B1<A1 set format/pattern/choose pink
>> >>>
>> >>>Regards,
>> >>>Stefi
>> >>>
>> >>>
>> >>>„Minâ€? ezt Ã*rta:
>> >>>
>> >>>
>> >>>>I have 2 columns of data.
>> >>>>If the number in b1 is less than a1, I want the number in b1 to be displayed
>> >>>>in pink.
>> >>>>How do I do this?
>> >>>>Many thanks for any help!
>>
>> .
>>

Thanks Gord. I don't know VBA, but I will take a look to see what I can find
out.

"Gord Dibben" wrote:

> There is no easy way to CF a cell based upon the value of a cell in another
> worksheet.
>
> Probably have to go with VBA
>
>
> Gord
>
> On Wed, 17 Feb 2010 15:24:01 -0800, mturboman
> <(E-Mail Removed)> wrote:
>
> >Thanks for the reply Gord.
> >
> >I do have a question though, is there an easier or better way to accomplish
> >this, as I am currently looking to review about 1500 cells with this criteria
> >on Tab 3 and looking to Tab 1 and Tab 2 to evaluate would be a lot of named
> >ranges. Is there a better more efficient way that I can format the cell in
> >Tab 3, using data in the same cell of Tab 1 and Tab2 to evaluate the color of
> >the cell on Tab 3?
> >
> >Thanks,
> >Mturboman
> >
> >"Gord Dibben" wrote:
> >
> >> You can refer to another sheet for CF only if you define a name for cell on
> >> other sheet.
> >>
> >> i.e. defined name "apple" refers to =Sheet2!A1
> >>
> >> Example........On Sheet1 in A1 CF>Formula is: =A1<ABS(apple)
> >>
> >>
> >> Gord Dibben MS Excel MVP
> >>
> >> On Thu, 04 Feb 2010 08:20:31 -0600, Bob I <(E-Mail Removed)> wrote:
> >>
> >> >You need to specify the Sheet name in addition to the cell if it is not
> >> >on the same sheet eg Sheet2!A1
> >> >
> >> >mturboman wrote:
> >> >
> >> >> I have a similar question, only my problem is i want to evaluate A1 on tab1,
> >> >> vs A1 on tab2, and apply a color pattern if A1 on tab1 ABS<1 and A1 on tab2
> >> >> ABS>1. How can I do this, as conditional formatting does not allow other
> >> >> tabs or files?
> >> >>
> >> >> Thanks
> >> >> Mike
> >> >>
> >> >> "Stefi" wrote:
> >> >>
> >> >>
> >> >>>Select column B
> >> >>>Formats/Conditional formatting
> >> >>>Choose formula as criterium
> >> >>>Formula: =B1<A1 set format/pattern/choose pink
> >> >>>
> >> >>>Regards,
> >> >>>Stefi
> >> >>>
> >> >>>
> >> >>>„Minâ€? ezt ÃÂ*rta:
> >> >>>
> >> >>>
> >> >>>>I have 2 columns of data.
> >> >>>>If the number in b1 is less than a1, I want the number in b1 to be displayed
> >> >>>>in pink.
> >> >>>>How do I do this?
> >> >>>>Many thanks for any help!
> >>
> >> .
> >>
>
> .
>