Home   News  Product reviews  Website reviews  Forums   Competitions  Subscribe 

Software >> Other Software
 |  Print Topic
Jump to first unread post. Pages: 1
ste01
new user


Reg'd: Mon
Posts: 2
excel 2007
      #370955 - Mon Nov 05 2007 04:13 PM

hi there all,
i have a quick question, how do you turn the colour of the text to a different colour??

for example if you outcome is negitive the number will automaticly turn red.

any help would be great.

ste


Post Extras: Print Post   Remind Me!   Notify Moderator  
greystsModerator
regular


Reg'd: Thu
Posts: 17961
Loc: Colchester
Re: excel 2007 [Re: ste01]
      #371079 - Tue Nov 06 2007 02:12 PM

Highlight the cell or group of cells in question then choose Format, Cells, Number, Number then choose Negative Numbers shown in red. At least that's how you do it in Excel 2003.

--------------------


Do you know that we're all in line for succession to the throne? Really?
Well, if forty-eight million, two hundred thousand, seven hundred and one people died I'd be Queen.


Post Extras: Print Post   Remind Me!   Notify Moderator  
ste01
new user


Reg'd: Mon
Posts: 2
Re: excel 2007 [Re: greysts]
      #371092 - Tue Nov 06 2007 04:36 PM

thankyou very much, i did know how to do that once, forgot though, its been a long time.

cheers .


Post Extras: Print Post   Remind Me!   Notify Moderator  
Pages: 1

Rate this topic

Jump to


Extra information
0 registered and 2 anonymous users are browsing this forum.

Moderator:  Mouse, Hello_There, greysts, bricat, Joe_London, putasolutions, John_McKenna, Nanook, TheFatControlleR 


Print Topic

Forum Permissions
      You cannot start new topics
      You cannot reply to topics
      HTML is disabled
      Mark-up is enabled

Rating:
Topic views: 0

Contact Us | Privacy statement Main website
Hitwise Top 10 Award Winner - Jan-Mar 2005

About us | Contact us | Link to us | Terms & Conditions | Privacy Policy
© Copyright IPC Media Limited, All rights reserved