Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
Sum Function sometimes displays incorrect answer | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions |