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!