| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting? Bold
Is this possible?
I have 2 sheets....If A1 on sheet two is 0 then I need Sheet one A1 to be bold. I am running XP. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formatting? Bold
Hi
With cursor in cell A1 on Sheet1, FormatConditional Formattinguse dropdown for Formula is Enter =Sheet2!$A$10 FormatChoose FontBold -- Regards Roger Govier "Inspector" wrote in message ... Is this possible? I have 2 sheets....If A1 on sheet two is 0 then I need Sheet one A1 to be bold. I am running XP. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formatting? Bold
Okay, I understand that. I gave you a general scenario. My actual scenario
is this: On sheet one in cell F2 is the following: =IF( COUNTIF('NOV-SAT-8'!A:A,A2), VLOOKUP(A2, 'NOV-SAT-8'!A:U, 14, FALSE)+VLOOKUP(A2,'NOV-SAT-8'!A:U,21,FALSE),"") The cell I want to reference on sheet two could be anywhere in column U as you can see by the formula, so if that cell somewhere in column U is 0 then I need sheet one F2 to be bold. How would I fit that in with the formula above? "Roger Govier" wrote: Hi With cursor in cell A1 on Sheet1, FormatConditional Formattinguse dropdown for Formula is Enter =Sheet2!$A$10 FormatChoose FontBold -- Regards Roger Govier "Inspector" wrote in message ... Is this possible? I have 2 sheets....If A1 on sheet two is 0 then I need Sheet one A1 to be bold. I am running XP. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formatting? Bold
How about,
=VLOOKUP(A2,'NOV-SAT-8'!A:U,21,FALSE)0 HTH Kostis Vezerides Inspector wrote: Okay, I understand that. I gave you a general scenario. My actual scenario is this: On sheet one in cell F2 is the following: =IF( COUNTIF('NOV-SAT-8'!A:A,A2), VLOOKUP(A2, 'NOV-SAT-8'!A:U, 14, FALSE)+VLOOKUP(A2,'NOV-SAT-8'!A:U,21,FALSE),"") The cell I want to reference on sheet two could be anywhere in column U as you can see by the formula, so if that cell somewhere in column U is 0 then I need sheet one F2 to be bold. How would I fit that in with the formula above? "Roger Govier" wrote: Hi With cursor in cell A1 on Sheet1, FormatConditional Formattinguse dropdown for Formula is Enter =Sheet2!$A$10 FormatChoose FontBold -- Regards Roger Govier "Inspector" wrote in message ... Is this possible? I have 2 sheets....If A1 on sheet two is 0 then I need Sheet one A1 to be bold. I am running XP. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formatting? Bold
oKAY, WHEN i TRY TO PUT THIS IN THE CONDITIONAL FORMATTING BOX IT REPLACES
THE ORIGINAL FORMULA. hOW CAN i INTEGRATE THIS INTO THE FORMULA BELOW? "vezerid" wrote: How about, =VLOOKUP(A2,'NOV-SAT-8'!A:U,21,FALSE)0 HTH Kostis Vezerides Inspector wrote: Okay, I understand that. I gave you a general scenario. My actual scenario is this: On sheet one in cell F2 is the following: =IF( COUNTIF('NOV-SAT-8'!A:A,A2), VLOOKUP(A2, 'NOV-SAT-8'!A:U, 14, FALSE)+VLOOKUP(A2,'NOV-SAT-8'!A:U,21,FALSE),"") The cell I want to reference on sheet two could be anywhere in column U as you can see by the formula, so if that cell somewhere in column U is 0 then I need sheet one F2 to be bold. How would I fit that in with the formula above? "Roger Govier" wrote: Hi With cursor in cell A1 on Sheet1, FormatConditional Formattinguse dropdown for Formula is Enter =Sheet2!$A$10 FormatChoose FontBold -- Regards Roger Govier "Inspector" wrote in message ... Is this possible? I have 2 sheets....If A1 on sheet two is 0 then I need Sheet one A1 to be bold. I am running XP. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formatting? Bold
What do you mean it replaces the original formula? The one in the CF
box? From what I understand, one thing is your function in F6 (IF...) and another is the condition for your format, which is based on only part of your formula. Can you be clearer? Kostis Inspector wrote: oKAY, WHEN i TRY TO PUT THIS IN THE CONDITIONAL FORMATTING BOX IT REPLACES THE ORIGINAL FORMULA. hOW CAN i INTEGRATE THIS INTO THE FORMULA BELOW? "vezerid" wrote: How about, =VLOOKUP(A2,'NOV-SAT-8'!A:U,21,FALSE)0 HTH Kostis Vezerides Inspector wrote: Okay, I understand that. I gave you a general scenario. My actual scenario is this: On sheet one in cell F2 is the following: =IF( COUNTIF('NOV-SAT-8'!A:A,A2), VLOOKUP(A2, 'NOV-SAT-8'!A:U, 14, FALSE)+VLOOKUP(A2,'NOV-SAT-8'!A:U,21,FALSE),"") The cell I want to reference on sheet two could be anywhere in column U as you can see by the formula, so if that cell somewhere in column U is 0 then I need sheet one F2 to be bold. How would I fit that in with the formula above? "Roger Govier" wrote: Hi With cursor in cell A1 on Sheet1, FormatConditional Formattinguse dropdown for Formula is Enter =Sheet2!$A$10 FormatChoose FontBold -- Regards Roger Govier "Inspector" wrote in message ... Is this possible? I have 2 sheets....If A1 on sheet two is 0 then I need Sheet one A1 to be bold. I am running XP. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formatting? Bold
Okay, I'll try....I click on the cell I want to format....which contains the
formula =IF( COUNTIF('NOV-SAT-8'!A:A,A2), VLOOKUP(A2, 'NOV-SAT-8'!A:U, 14,FALSE)+VLOOKUP(A2,'NOV-SAT-8'!A:U,21,FALSE),"")....I go to Formatconditional format, and choose Formula is: and when I begin to enter the formula that you gave me, it replaces my original formula. "vezerid" wrote: What do you mean it replaces the original formula? The one in the CF box? From what I understand, one thing is your function in F6 (IF...) and another is the condition for your format, which is based on only part of your formula. Can you be clearer? Kostis Inspector wrote: oKAY, WHEN i TRY TO PUT THIS IN THE CONDITIONAL FORMATTING BOX IT REPLACES THE ORIGINAL FORMULA. hOW CAN i INTEGRATE THIS INTO THE FORMULA BELOW? "vezerid" wrote: How about, =VLOOKUP(A2,'NOV-SAT-8'!A:U,21,FALSE)0 HTH Kostis Vezerides Inspector wrote: Okay, I understand that. I gave you a general scenario. My actual scenario is this: On sheet one in cell F2 is the following: =IF( COUNTIF('NOV-SAT-8'!A:A,A2), VLOOKUP(A2, 'NOV-SAT-8'!A:U, 14, FALSE)+VLOOKUP(A2,'NOV-SAT-8'!A:U,21,FALSE),"") The cell I want to reference on sheet two could be anywhere in column U as you can see by the formula, so if that cell somewhere in column U is 0 then I need sheet one F2 to be bold. How would I fit that in with the formula above? "Roger Govier" wrote: Hi With cursor in cell A1 on Sheet1, FormatConditional Formattinguse dropdown for Formula is Enter =Sheet2!$A$10 FormatChoose FontBold -- Regards Roger Govier "Inspector" wrote in message ... Is this possible? I have 2 sheets....If A1 on sheet two is 0 then I need Sheet one A1 to be bold. I am running XP. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formatting? Bold
Just a note:
If you want to refer to another worksheet in your CF formula, there are a few different approaches to try. See this google search thread for some. http://snipurl.com/15ca7 Gord Dibben MS Excel MVP On Tue, 19 Dec 2006 10:16:01 -0800, Inspector wrote: oKAY, WHEN i TRY TO PUT THIS IN THE CONDITIONAL FORMATTING BOX IT REPLACES THE ORIGINAL FORMULA. hOW CAN i INTEGRATE THIS INTO THE FORMULA BELOW? "vezerid" wrote: How about, =VLOOKUP(A2,'NOV-SAT-8'!A:U,21,FALSE)0 HTH Kostis Vezerides Inspector wrote: Okay, I understand that. I gave you a general scenario. My actual scenario is this: On sheet one in cell F2 is the following: =IF( COUNTIF('NOV-SAT-8'!A:A,A2), VLOOKUP(A2, 'NOV-SAT-8'!A:U, 14, FALSE)+VLOOKUP(A2,'NOV-SAT-8'!A:U,21,FALSE),"") The cell I want to reference on sheet two could be anywhere in column U as you can see by the formula, so if that cell somewhere in column U is 0 then I need sheet one F2 to be bold. How would I fit that in with the formula above? "Roger Govier" wrote: Hi With cursor in cell A1 on Sheet1, FormatConditional Formattinguse dropdown for Formula is Enter =Sheet2!$A$10 FormatChoose FontBold -- Regards Roger Govier "Inspector" wrote in message ... Is this possible? I have 2 sheets....If A1 on sheet two is 0 then I need Sheet one A1 to be bold. I am running XP. |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formatting? Bold
thank you , I'll try it.
"Gord Dibben" wrote: Just a note: If you want to refer to another worksheet in your CF formula, there are a few different approaches to try. See this google search thread for some. http://snipurl.com/15ca7 Gord Dibben MS Excel MVP On Tue, 19 Dec 2006 10:16:01 -0800, Inspector wrote: oKAY, WHEN i TRY TO PUT THIS IN THE CONDITIONAL FORMATTING BOX IT REPLACES THE ORIGINAL FORMULA. hOW CAN i INTEGRATE THIS INTO THE FORMULA BELOW? "vezerid" wrote: How about, =VLOOKUP(A2,'NOV-SAT-8'!A:U,21,FALSE)0 HTH Kostis Vezerides Inspector wrote: Okay, I understand that. I gave you a general scenario. My actual scenario is this: On sheet one in cell F2 is the following: =IF( COUNTIF('NOV-SAT-8'!A:A,A2), VLOOKUP(A2, 'NOV-SAT-8'!A:U, 14, FALSE)+VLOOKUP(A2,'NOV-SAT-8'!A:U,21,FALSE),"") The cell I want to reference on sheet two could be anywhere in column U as you can see by the formula, so if that cell somewhere in column U is 0 then I need sheet one F2 to be bold. How would I fit that in with the formula above? "Roger Govier" wrote: Hi With cursor in cell A1 on Sheet1, FormatConditional Formattinguse dropdown for Formula is Enter =Sheet2!$A$10 FormatChoose FontBold -- Regards Roger Govier "Inspector" wrote in message ... Is this possible? I have 2 sheets....If A1 on sheet two is 0 then I need Sheet one A1 to be bold. I am running XP. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting | Excel Discussion (Misc queries) | |||
| cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions | |||
| enhanced conditional formatting | Excel Discussion (Misc queries) | |||
| conditional formatting question | Excel Discussion (Misc queries) | |||
| conditional formatting conflict? | Excel Worksheet Functions | |||
Linear Mode
