Coloring data in Excel automatically

[Rich Bail]

I would like to color the data if one particular column is greater than
another.

Say column X has a data entry of 50 and column Y has a data entry of 45,
then column X is greater than column Y. In which case I would like the data
to be in blue and bold. If Y was greater than X I would want that column to
be bold blue.

How can I do this?

[MikeY]

Rich,

This newsgroup is for Japanese.
I think you should have posted in US newsgroup like "microsoft.public.excel.worksheet.functions."
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.excel.worksheet.functions&cat=en_US_fa309293-a5be-4e65-baa1-aba02f59a1fa&lang=en&cr=US

Anyway....

Use [Format]-[Conditional Formatting] commands.

=AND(COUNT(X1:Y1)=2,X1>Y1) for Cell X1
=AND(COUNT(X1:Y1)=2,X1<Y1) for Cell Y1

--
Mike

"Rich Bail" <theb...@earthlink.net> wrote in message news:%23Xptp$HFGHA...@TK2MSFTNGP10.phx.gbl...