Answer in Red in =IF function
 

Is there a way for the value to be returned in Red (or italics, or bold,
etc.) if the result of an =IF function is false in a particular cell and
another format if it is true?

How can this be done.

Thanks for your help.

Look at Conditional Formatting in Help.

On Sat, 5 Mar 2005 19:01:02 -0800, "Tenacity"
wrote:

Is there a way for the value to be returned in Red (or italics, or bold,
etc.) if the result of an =IF function is false in a particular cell and
another format if it is true?

How can this be done.

Thanks for your help.

Actually, try 'Highlight cells that meet specific conditions' in the Answer
wizard

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Myrna Larson" wrote in message
...
Look at Conditional Formatting in Help.

On Sat, 5 Mar 2005 19:01:02 -0800, "Tenacity"
wrote:

Is there a way for the value to be returned in Red (or italics, or bold,
etc.) if the result of an =IF function is false in a particular cell and
another format if it is true?

How can this be done.

Thanks for your help.