Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can i make text in cells c60@n60 bold & black if sum of C59 is gre
I'v ebeen trying to work this out but honestly i'm more face to face than
cell to cell! Can anyone advise me? I'm using MSOffice 2007 -- Doing someowt is better than doing nowt! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can i make text in cells c60@n60 bold & black if sum of C59 is gre
Sorry meant to type "Can i make text in cells c60:n60 bold & black if sum of
C59 is greater than 1 -- Doing someowt is better than doing nowt! "Spartan C10" wrote: I'v ebeen trying to work this out but honestly i'm more face to face than cell to cell! Can anyone advise me? I'm using MSOffice 2007 -- Doing someowt is better than doing nowt! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can i make text in cells c60@n60 bold & black if sum of C59 is gre
Isn't the text already black? That's the default text color.
Try this: Select the range of cells C60:N60 Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a formula to determine which cells to format Enter this formula in the box below: =N($C$59)1 Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "Spartan C10" wrote in message ... Sorry meant to type "Can i make text in cells c60:n60 bold & black if sum of C59 is greater than 1 -- Doing someowt is better than doing nowt! "Spartan C10" wrote: I'v ebeen trying to work this out but honestly i'm more face to face than cell to cell! Can anyone advise me? I'm using MSOffice 2007 -- Doing someowt is better than doing nowt! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can i make text in cells c60@n60 bold & black if sum of C59 is gre
Use conditional formatting. Highlight cells c60:n60. Use FormatConditional
Formatting...Formula is: =$C$591 (format bold, black) Regards, Fred. "Spartan C10" wrote in message ... Sorry meant to type "Can i make text in cells c60:n60 bold & black if sum of C59 is greater than 1 -- Doing someowt is better than doing nowt! "Spartan C10" wrote: I'v ebeen trying to work this out but honestly i'm more face to face than cell to cell! Can anyone advise me? I'm using MSOffice 2007 -- Doing someowt is better than doing nowt! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can i make text in cells c60@n60 bold & black if sum of C59 is
Thanks for this one, it works in cells where i only have numbers, but where
there is descriptive text the formatting isn't applied. I'm in UK so sorry about the time difference. Any ideas? -- Doing someowt is better than doing nowt! "T. Valko" wrote: Isn't the text already black? That's the default text color. Try this: Select the range of cells C60:N60 Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a formula to determine which cells to format Enter this formula in the box below: =N($C$59)1 Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "Spartan C10" wrote in message ... Sorry meant to type "Can i make text in cells c60:n60 bold & black if sum of C59 is greater than 1 -- Doing someowt is better than doing nowt! "Spartan C10" wrote: I'v ebeen trying to work this out but honestly i'm more face to face than cell to cell! Can anyone advise me? I'm using MSOffice 2007 -- Doing someowt is better than doing nowt! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can i make text in cells c60@n60 bold & black if sum of C59 is
Thanks for this, it works where the cells only contain numbers but not where
they contain text. Any ideas? -- Doing someowt is better than doing nowt! "T. Valko" wrote: Isn't the text already black? That's the default text color. Try this: Select the range of cells C60:N60 Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a formula to determine which cells to format Enter this formula in the box below: =N($C$59)1 Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "Spartan C10" wrote in message ... Sorry meant to type "Can i make text in cells c60:n60 bold & black if sum of C59 is greater than 1 -- Doing someowt is better than doing nowt! "Spartan C10" wrote: I'v ebeen trying to work this out but honestly i'm more face to face than cell to cell! Can anyone advise me? I'm using MSOffice 2007 -- Doing someowt is better than doing nowt! |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can i make text in cells c60@n60 bold & black if sum of C59 is
You said you wanted to format cells when cell C59 is 1. I don't understand
what TEXT entries have to do with it. How can a text entry be 1? -- Biff Microsoft Excel MVP "Spartan C10" wrote in message ... Thanks for this, it works where the cells only contain numbers but not where they contain text. Any ideas? -- Doing someowt is better than doing nowt! "T. Valko" wrote: Isn't the text already black? That's the default text color. Try this: Select the range of cells C60:N60 Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a formula to determine which cells to format Enter this formula in the box below: =N($C$59)1 Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "Spartan C10" wrote in message ... Sorry meant to type "Can i make text in cells c60:n60 bold & black if sum of C59 is greater than 1 -- Doing someowt is better than doing nowt! "Spartan C10" wrote: I'v ebeen trying to work this out but honestly i'm more face to face than cell to cell! Can anyone advise me? I'm using MSOffice 2007 -- Doing someowt is better than doing nowt! |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can i make text in cells c60@n60 bold & black if sum of C59 is
Assuming I understand you correctly, in C60, use a conditional format of :
=AND(N($C$59)1,NOT(ISTEXT(C60))) and copy across the formatting. Regards, Fred. "Spartan C10" wrote in message ... Thanks for this, it works where the cells only contain numbers but not where they contain text. Any ideas? -- Doing someowt is better than doing nowt! "T. Valko" wrote: Isn't the text already black? That's the default text color. Try this: Select the range of cells C60:N60 Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a formula to determine which cells to format Enter this formula in the box below: =N($C$59)1 Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "Spartan C10" wrote in message ... Sorry meant to type "Can i make text in cells c60:n60 bold & black if sum of C59 is greater than 1 -- Doing someowt is better than doing nowt! "Spartan C10" wrote: I'v ebeen trying to work this out but honestly i'm more face to face than cell to cell! Can anyone advise me? I'm using MSOffice 2007 -- Doing someowt is better than doing nowt! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel, colored text is printing in black. Shaded cells are ok? | Excel Discussion (Misc queries) | |||
How do I make my borded automatic black instead of pink? | Excel Worksheet Functions | |||
Join bold and non-bold text in one cell | Excel Discussion (Misc queries) | |||
How to edit the size and make it bold of the Option Button text? | Excel Discussion (Misc queries) | |||
how do I 'count' the number of cells with a text in red or black? | Excel Worksheet Functions |