corsasport.co.uk
  Not logged in [Login - Register]  
You Are Not Registered Or Not Logged In  

Corsa Sport » Message Board » Off Day » Geek Day » Bit of Excel help


New Topic
New Poll 		  Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author Bit of Excel help
Aaron
Member
Registered: 9th Aug 04
Location: Cottingham, East Riding
User status: Offline
8th Nov 08 at 23:57   View User's Profile U2U Member Reply With Quote
Is there a formula which will turn the background of a cell (or even the text of the cell) red if the value is anything below that of £0?

If so, anyone know it?
richardworrall
Premium Member

Registered: 20th Sep 05
Location: Derby
User status: Offline
9th Nov 08 at 00:09   View Garage View User's Profile U2U Member Reply With Quote
something to do with conditional formating in the format menu if i remember right

[Edited on 09-11-2008 by richardworrall]
Aaron
Member
Registered: 9th Aug 04
Location: Cottingham, East Riding
User status: Offline
9th Nov 08 at 00:11   View User's Profile U2U Member Reply With Quote
Sorted it
Gaz
Member
Registered: 24th Aug 03
Location: Widnes, Cheshire
User status: Offline
9th Nov 08 at 15:46   View User's Profile U2U Member Reply With Quote
quote:
Originally posted by richardworrall
something to do with conditional formating in the format menu if i remember right

[Edited on 09-11-2008 by richardworrall]



Or you can just have the text turn red as a negative sum in the format options of the cell.
Aaron
Member
Registered: 9th Aug 04
Location: Cottingham, East Riding
User status: Offline
9th Nov 08 at 15:50   View User's Profile U2U Member Reply With Quote
quote:
Originally posted by Gaz
quote:
Originally posted by richardworrall
something to do with conditional formating in the format menu if i remember right

[Edited on 09-11-2008 by richardworrall]



Or you can just have the text turn red as a negative sum in the format options of the cell.


Thats exaxtly what i did
ed
Member
Registered: 10th Sep 03
User status: Offline
10th Nov 08 at 00:06   View User's Profile U2U Member Reply With Quote
Happens by default if you set the cell format to money doesn't it?

 
New Topic
New Poll

  Related Threads Author Forum Replies Views Last Post
Help needed again ...Trotty can you help Red_Corsa Geek Day 17 1750
21st Mar 03 at 00:15
by Red_Corsa		  
Any MS Excel experts Steve Geek Day 11 1360
4th Jun 04 at 14:19
by blebo		  
is there a program that...... chris_uk Geek Day 6 1967
16th Jun 05 at 00:47
by Dan B		  
Excel Help AndyKent Geek Day 3 1526
6th Oct 07 at 10:22
by aPk		  
need an excel like programme (for free) Shane Geek Day 12 1861
13th May 08 at 14:55
by pow		  

Corsa Sport » Message Board » Off Day » Geek Day » Bit of Excel help 28 database queries in 0.0138068 seconds