View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default 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!