Having numbers automatically appear bold

[saxter]

Hi all,

Had such great advise last time, thought I'd try again.

I have a large range of cells where I will be inputing sales figures i
the form of currency revenue. The range is about G-I and 1-400. Th
sales data will be a comparisson of YTD 2001 - 2004 revenue results.

What I hope to do is have any figure that is above $30,000 appea
automatically in bold so as to stand out as a good client. I gues
there is something in the IF function to do this but I'm stumped.

Any ideas?

Thanks again in advance.

Saxte

 

[sokevin]

select the range you want to format

Format -> conditional Format ... pretty easy from there....


good luck :

 

[Guest]

You can use conditional formatting.

You can find it in Help or read an article with steps about it at:
http://office.microsoft.com/assista...CTT=1&Origin=EC010229831033&QueryID=dUz4NJR6k