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

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
 
S

Spartan C10

Sorry meant to type "Can i make text in cells c60:n60 bold & black if sum of
C59 is greater than 1
 
T

T. Valko

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
 
F

Fred Smith

Use conditional formatting. Highlight cells c60:n60. Use Format>Conditional
Formatting...>Formula is:

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

Regards,
Fred.
 
S

Spartan C10

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?
 
S

Spartan C10

Thanks for this, it works where the cells only contain numbers but not where
they contain text. Any ideas?
 
T

T. Valko

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?
 
F

Fred Smith

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.
 
Top