| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#14
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#15
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#16
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#17
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#18
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change font color for row | New Users to Excel | |||
| not able to see font color change. | Excel Discussion (Misc queries) | |||
| Can I change font/color if value is less than another value? | Excel Discussion (Misc queries) | |||
| how can I conditionally change font color, or background color? | Excel Worksheet Functions | |||
| How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) | |||
Linear Mode
