Can i make text in cells c60@n60 bold & black if sum of C59 is gre

  • Thread starter Thread starter Spartan C10
  • Start date Start date
S

Spartan C10

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
 
Sorry meant to type "Can i make text in cells c60:n60 bold & black if sum of
C59 is greater than 1
 
Isn't the text already black? That's the default text color.

Try this:

Select the range of cells C60:N60
Goto Home tab>Styles>Conditional Formatting>Manage rules>New rule>Use 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
 
Use conditional formatting. Highlight cells c60:n60. Use Format>Conditional
Formatting...>Formula is:

=$C$59>1
(format bold, black)

Regards,
Fred.
 
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?
 
Thanks for this, it works where the cells only contain numbers but not where
they contain text. Any ideas?
 
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?
 
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.
 
Back
Top