Change font colour
 

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!

Change font colour
 

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!

Change font colour
 

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!

Change font colour
 

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
ABS1. 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!

Change font colour
 

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
ABS1. 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!

Change font colour
 

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 CFFormula is: =A1<ABS(apple)


Gord Dibben MS Excel MVP

On Thu, 04 Feb 2010 08:20:31 -0600, Bob I 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
ABS1. 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!

Change font colour
 

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 CFFormula is: =A1<ABS(apple)


Gord Dibben MS Excel MVP

On Thu, 04 Feb 2010 08:20:31 -0600, Bob I 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
ABS1. 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!

Change font colour
 

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 CFFormula is: =A1<ABS(apple)


Gord Dibben MS Excel MVP

On Thu, 04 Feb 2010 08:20:31 -0600, Bob I 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
ABS1. 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!

.

Change font colour
 

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
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 CFFormula is: =A1<ABS(apple)


Gord Dibben MS Excel MVP

On Thu, 04 Feb 2010 08:20:31 -0600, Bob I 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
ABS1. 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!

.

Change font colour
 

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
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 CFFormula is: =A1<ABS(apple)


Gord Dibben MS Excel MVP

On Thu, 04 Feb 2010 08:20:31 -0600, Bob I 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
ABS1. 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!

.


.