Another Excel Problem

[Darthshearer]

Guys

Another excel one for thee.

I have several cells with a percentage in. I want the colour of the text (not the cell) to change colour during these ranges:

0-25%
26-50%
51-75%
76-100%

I can find where to change the cell colour (I think) but not the text. Any help is mucho appreciated

 

[MYstIC G]

Excel 2007
Home Toolbar
Conditional Formatting Button
New Rule
Select "Use a formula" to determine and put in your settings with the format button.

 

[Darthshearer]

Cheers Man

Now, I have a group of number, i.e from Cells F50-F60 How do I put that in?

Sorry for numpty Q

 

[MYstIC G]

Damn you I just closed the example spreadsheet!

Didn't catch that you needed to do a range. Hilight the range and use the "format only cells that contain" option. You can then stack these to change them.

PS: it's a lowercase p to do the smiley...

 

[Darthshearer]

Legend, Cheers Man
+rep