PC Review


Reply
Thread Tools Rate Thread

How can I change the color of an "IF" function answer?

 
 
=?Utf-8?B?RWxtbz8=?=
Guest
Posts: n/a
 
      26th Feb 2006
How can I have "EXCEL" dislpay an "IF" function answer in a specific color
that I choose.
 
Reply With Quote
 
 
 
 
Bob Phillips
Guest
Posts: n/a
 
      26th Feb 2006
Look at conditional formatting in help.


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Elmo?" <Elmo?@discussions.microsoft.com> wrote in message
news:1648E728-7E3C-4BC0-A907-(E-Mail Removed)...
> How can I have "EXCEL" dislpay an "IF" function answer in a specific color
> that I choose.



 
Reply With Quote
 
Dave Peterson
Guest
Posts: n/a
 
      26th Feb 2006
Format|conditional formatting???

Debra Dalgleish explains it:
http://www.contextures.com/xlCondFormat01.html

Elmo? wrote:
>
> How can I have "EXCEL" dislpay an "IF" function answer in a specific color
> that I choose.


--

Dave Peterson
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I change the fill color of a cell using an "IF" function =?Utf-8?B?ZG9uc2NoYXA=?= Microsoft Excel Worksheet Functions 6 9th Mar 2010 03:48 PM
"Search" Function with answer prepared by Biff for Brantty on 01/0 =?Utf-8?B?RnJhbmNlcw==?= Microsoft Excel Misc 3 19th Aug 2005 05:46 AM
cell to change color =IF(B7>53,"Critical","Normal") =?Utf-8?B?Zmdpb3Jk?= Microsoft Excel Misc 3 18th Aug 2005 09:57 PM
how do i get answer is 1 from CELL("color",sth) function? =?Utf-8?B?VC5UaGluaA==?= Microsoft Excel Misc 1 24th Jun 2005 10:07 AM
Change Font Color With "If" Function Mike Microsoft Excel Misc 3 19th Nov 2003 06:51 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:29 PM.