Excel help - Corsa Sport - for Vauxhall and Opel Corsa B, Corsa C and Corsa D

Not logged in [Login - Register]

You Are Not Registered Or Not Logged In

Corsa Sport » Message Board » Off Day » Geek Day » 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.

paul.mitchell1984

Member

Registered: 31st Aug 06
Location: Wakefield
User status: Offline

7th Sep 06 at 13:49

gone have the college days when excel was easy and i new what i was doing.

i have created an "if" query that works spot on.

i now need to do conditional fomating so that if a figure is £300 it goes green and if it is £0 it goes red etc.

im wanting it so that if the figue is 300 and more its green and says paid in the below cell and if it is less than 300 or 0 then it goes red and says unpaid in the cell...

any body any ideas??

James

Member

Registered: 1st Jun 02
Location: Surrey
User status: Offline

7th Sep 06 at 13:58

Use conditional formatting for the colour and use a forumla like this for the wording.............

E.g. in Cell A2 put:

=if(a1=300,"Paid","Unpaid")

[Edited on 07-09-2006 by James]

--Dave--

Banned

Registered: 17th Feb 04
Location: Essssseeeeex Drives: Black Supra TT
User status: Offline

7th Sep 06 at 14:03

Well fcuk me shocking news as James posts something serious for once in his life