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!