You don't necessarily need a macro, unless you want more than 3 conditional
formats. Likely, you just need a formula CF:
http://www.officearticles.com/excel/...ft_ excel.htm

If you need the macro after all:
http://vbaexpress.com/kb/getarticle.php?kb_id=90
************
Anne Troy
www.OfficeArticles.com

"PiPPo" wrote in message
oups.com...
Hi,
This is my problem. I would like to format a number in B1 on the basis
of a certain condition in A1.
I read in another post that I need a macro to conditional format
numbers. Is that correct? Where can I find such macro? If this is not
the case, can anyone help me with my problem?

Thank you,

Pippo