conditional formating will work for the colors and the bold , then a simple
if function will work to
produce the word, conditional formating is the only way to bold and color
the format of the text
in styles click conditional formiting (highlight the range first), then
select new rule, and then "format text that contains"
then in the drop down select spefic text and the type the text you would
like to auto format click
format and then do what ever you please

"John" wrote:

I am using Office Exel 2007 and I am having trouble getting the data to
display the way I want it to by using the IF function to test the cell. My
situation is as follows

I have cell C25 Formatted for accounting and the value is $0.00. Currnetly,
the value in the cell is shown as " $ - ". Instead of showing this I want
to do something like the example as follows:

If the dollar amount in C25 is equal to 0, then display "PAID" in bold
letters with geen fill, If the dollar amount in C25 is equal to or greather
than $5.00, then I want the dollar amount to be displayed.

How can I make this happen?
Please reply ASAP.

Thank you,
--
John R. L.