Prev: Using VLookup with 2 Workbooks
Next: How do I truncate linked text?
From: SilviaG on 9 Apr 2010 12:50
I have formula =min(312,200+8) and im trying to add the IF function to it as
well, with the logic that if 0<312 that the text will change a certain color
if true and a different color if its false. Is there a way to do this?

From: Dulanic on 9 Apr 2010 13:21

SilviaG;695091 Wrote:
>
I have formula =min(312,200+8) and im trying to add the IF function to
it as
> well, with the logic that if 0<312 that the text will change a certain
color
> if true and a different color if its false. Is there a way to do
this?



Use conditional formatting? Functions can't change formatting itself.


--
Dulanic
------------------------------------------------------------------------
Dulanic's Profile: 1734
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=194401

http://www.thecodecage.com/forumz

From: "David Biddulph" groups [at] on 9 Apr 2010 13:26
To change colour based on a condition, the feature you want to look up in
Excel help is "conditional formatting".
--
David Biddulph


"SilviaG" <SilviaG(a)discussions.microsoft.com> wrote in message
news:9E3143B5-209A-4FE1-9968-A5F3C33B48E8(a)microsoft.com...
> I have formula =min(312,200+8) and im trying to add the IF function to it
> as
> well, with the logic that if 0<312 that the text will change a certain
> color
> if true and a different color if its false. Is there a way to do this?
>

 | 
Pages: 1
Prev: Using VLookup with 2 Workbooks
Next: How do I truncate linked text?