Change font color as part of if/then
 

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."
--
tina

Change font color as part of if/then
 

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

--
HTH...

Jim Thomlinson


"tina" wrote:

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."
--
tina

Change font color as part of if/then
 

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.
--
David Biddulph

"tina" wrote in message
...
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."
--
tina

Change font color as part of if/then
 

I am so totally going to try that!

Hold please...
--
tina


"Jim Thomlinson" wrote:

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

--
HTH...

Jim Thomlinson


"tina" wrote:

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."
--
tina

Doesn't work with outside worksheet reference
 

My IF/THEN looks like this:

-- =IF('Data Input'!BC1470,'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


"David Biddulph" wrote:

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.
--
David Biddulph

"tina" wrote in message
...
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."
--
tina

Doesn't work with outside worksheet reference
 

craaaaaaap!!!

that's so lame :-(

;-)
--
tina


"tina" wrote:

My IF/THEN looks like this:

-- =IF('Data Input'!BC1470,'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


"David Biddulph" wrote:

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.
--
David Biddulph

"tina" wrote in message
...
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."
--
tina

Doesn't work with outside worksheet reference
 

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

"tina" wrote in message
...
My IF/THEN looks like this:

-- =IF('Data Input'!BC1470,'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


"David Biddulph" wrote:

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.
--
David Biddulph

"tina" wrote in message
...
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."
--
tina

Doesn't work with outside worksheet reference
 

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!!!!
--
tina


"David Biddulph" wrote:

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

"tina" wrote in message
...
My IF/THEN looks like this:

-- =IF('Data Input'!BC1470,'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


"David Biddulph" wrote:

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.
--
David Biddulph

"tina" wrote in message
...
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."
--
tina

Doesn't work with outside worksheet reference
 

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.
--
David Biddulph

"tina" wrote in message
...
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!!!!
--
tina


"David Biddulph" wrote:

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

"tina" wrote in message
...
My IF/THEN looks like this:

-- =IF('Data Input'!BC1470,'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


"David Biddulph" wrote:

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.
--
David Biddulph

"tina" wrote in message
...
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."
--
tina

Doesn't work with outside worksheet reference
 

Tina

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

Select Data Input BC147 and InsertName define.

Name it CFrange or similar

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

In CFFormula is: =CFrange0 Format to a pattern and OK

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


Gord Dibben MS Excel MVP


On Tue, 29 Jan 2008 10:39:00 -0800, tina wrote:

My IF/THEN looks like this:

-- =IF('Data Input'!BC1470,'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


"David Biddulph" wrote:

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.
--
David Biddulph

"tina" wrote in message
...
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."
--
tina

Doesn't work with outside worksheet reference
 

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??? :-)
--
tina


"Gord Dibben" wrote:

Tina

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

Select Data Input BC147 and InsertName define.

Name it CFrange or similar

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

In CFFormula is: =CFrange0 Format to a pattern and OK

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


Gord Dibben MS Excel MVP


On Tue, 29 Jan 2008 10:39:00 -0800, tina wrote:

My IF/THEN looks like this:

-- =IF('Data Input'!BC1470,'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


"David Biddulph" wrote:

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.
--
David Biddulph

"tina" wrote in message
...
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."
--
tina

Doesn't work with outside worksheet reference
 

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
--
tina


"Gord Dibben" wrote:

Tina

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

Select Data Input BC147 and InsertName define.

Name it CFrange or similar

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

In CFFormula is: =CFrange0 Format to a pattern and OK

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


Gord Dibben MS Excel MVP


On Tue, 29 Jan 2008 10:39:00 -0800, tina wrote:

My IF/THEN looks like this:

-- =IF('Data Input'!BC1470,'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


"David Biddulph" wrote:

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.
--
David Biddulph

"tina" wrote in message
...
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."
--
tina

Doesn't work with outside worksheet reference
 

Not Gods, just regular folks who help out on these news groups.

See the info here.

http://mvp.support.microsoft.com/default.aspx

Application Problems as a news group does ring a bell.


Gord

On Wed, 30 Jan 2008 10:50:01 -0800, tina wrote:

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

Doesn't work with outside worksheet reference
 

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
--
tina


"Gord Dibben" wrote:

Not Gods, just regular folks who help out on these news groups.

See the info here.

http://mvp.support.microsoft.com/default.aspx

Application Problems as a news group does ring a bell.


Gord

On Wed, 30 Jan 2008 10:50:01 -0800, tina wrote:

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

Doesn't work with outside worksheet reference
 

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

On Thu, 31 Jan 2008 06:47:00 -0800, tina wrote:

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

Doesn't work with outside worksheet reference
 

Maybe a movie to rent...

http://www.imdb.com/title/tt0337909/



Gord Dibben wrote:

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

On Thu, 31 Jan 2008 06:47:00 -0800, tina wrote:

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

--

Dave Peterson

Doesn't work with outside worksheet reference
 

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
--
tina


"Dave Peterson" wrote:

Maybe a movie to rent...

http://www.imdb.com/title/tt0337909/



Gord Dibben wrote:

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

On Thu, 31 Jan 2008 06:47:00 -0800, tina wrote:

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

--

Dave Peterson

Doesn't work with outside worksheet reference
 

I didn't mean to.

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

tina wrote:

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
--
tina

"Dave Peterson" wrote:

Maybe a movie to rent...

http://www.imdb.com/title/tt0337909/



Gord Dibben wrote:

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

On Thu, 31 Jan 2008 06:47:00 -0800, tina wrote:

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

--

Dave Peterson


--

Dave Peterson