Change font colour

[Guest]

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!

 

[Guest]

Yoe are welcome! Thanks for the feedback!
Stefi


„Min†ezt írta:

 

[Guest]

Hi,

For more information on Conditional Formatting, refer to this link:
http://office.microsoft.com/en-us/excel/HA011366251033.aspx?pid=CL100570551033

Challa Prabhu

 

[mturboman]

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

 

[Bob I]

You need to specify the Sheet name in addition to the cell if it is not

 

[Gord Dibben]

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

 

[Bob I]

My bad, thanks!

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

 

[mturboman]

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]

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

 

[mturboman]

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