Change font color as part of if/then

T

tina

Is it possible that, within an IF/THEN statement, I could say IF x is true,
then "pull the number from specified worksheet and change the font color to
(for example) blue."
 
J

Jim Thomlinson

You need to use conditional formatting for that. Format -> Conditional Format
| Formula Is ...
 
D

David Biddulph

Look up "conditional formatting" in Excel help.

The process for changing the font colour is done by conditional formatting,
whereas putting the number in the cell is done by a normal formula. You can
use the same condition under "formula is" is conditional formatting as you
used in your condition in your IF formula.
 
T

tina

My IF/THEN looks like this:

-- =IF('Data Input'!BC147>0,'Data Input'!BC147,'GAAP details'!AY156*'GAAP
details'!AY151)

As you can see, it references another worksheet within the file. The
Conditional Formatting says I cannot use an outside worksheet as a criteria
for the conditional formatting - BUMMER!!! :-(

Any other thoughts???

tina
 
T

tina

craaaaaaap!!!

that's so lame :-(

;-)
--
tina


tina said:
My IF/THEN looks like this:

-- =IF('Data Input'!BC147>0,'Data Input'!BC147,'GAAP details'!AY156*'GAAP
details'!AY151)

As you can see, it references another worksheet within the file. The
Conditional Formatting says I cannot use an outside worksheet as a criteria
for the conditional formatting - BUMMER!!! :-(

Any other thoughts???

tina
Click to expand...
 
D

David Biddulph

You may want to use a helper column, hidden if you like, to do the test
='Data Input'!BC147>0 (and return TRUE or FALSE), and then use that column
as the input to your conditional formatting formukla.
 
T

tina

Ahhhhhhhh....you're good :)

The only issue I might have is that this is our 'budget model' - i.e. it's
pretty big, but not unmanageable - I'm going to look and see if this is
something 'doable' for the upcoming year's input....

Thanks!!!!
 
D

David Biddulph

I wouldn't dream of taking the credit. Much of what I know about those sort
of tricks with Excel is stuff which I've learned from this newsgroup.
 
G

Gord Dibben

Tina

You can reference another sheet in CF if you create a defined name.

Select Data Input BC147 and Insert>Name define.

Name it CFrange or similar

Example only.....................

In CF>Formula is: =CFrange>0 Format to a pattern and OK

I don't quite get why you would use that formula of your in a CF>Formula is:


Gord Dibben MS Excel MVP
 
T

tina

Thanks Gord - that's a new tool to me!

However, I decided what I was trying to accomplish was not worth the effort
required to get it all set up, so I bailed on the idea.

btw - what's an Excel MVP??? :)
 
T

tina

Hey! OK - my coworker told me that MVP's are like excel gods. With that in
mind, I have a post over in Application Problems (or whatever it's called)
that no one's answering.... :-D
 
T

tina

Dude! That's so totally cool!

OK - I went to the website...are you in featured in one of the months? (for
those reading, there is NOT like a Mr. January MVP and such....sorry to
disappoint :-D
 
G

Gord Dibben

If MS produced a Calendar like Fireman of the Month or similar, I would

definitely be a candidate for Mr."Month"

Unfortunately MS does not issue one.


Gord
 
T

tina

Gord - I'm not sure, but I think Dave just called you a middle aged woman...

:-D

(ok Mr. Excel Online Community police - I'll stop posting non-excel related
comments... :-D
 
D

Dave Peterson

I didn't mean to.

But he isn't the only oldtimer (cough, cough) who's had an idea for a calendar.
 
Top