Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Tenacity
 
Posts: n/a
Default 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.
  #2   Report Post  
Myrna Larson
 
Posts: n/a
Default

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.


  #3   Report Post  
Bob Phillips
 
Posts: n/a
Default

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.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hyperlinks using R[1]C[1] and offset function in its cell referenc Elijah-Dadda Excel Worksheet Functions 0 March 5th 05 03:31 AM
Conversion SVC Excel Worksheet Functions 9 February 28th 05 02:29 PM
Trim function doesn't clean out ASCII Code 160 (Space) Ronald Dodge Excel Worksheet Functions 6 January 27th 05 03:48 AM
Sum Function sometimes displays incorrect answer John Westgate Excel Worksheet Functions 4 January 18th 05 12:16 PM
Formula to list unique values JaneC Excel Worksheet Functions 4 December 10th 04 12:25 AM


All times are GMT +1. The time now is 04:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"