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

Corsa Sport » Message Board » Off Day » Geek Day » Excel conditonal formating - any ideas


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 Excel conditonal formating - any ideas
jr
Member
Registered: 20th May 02
Location: Kent
User status: Offline
22nd Sep 09 at 15:08   View User's Profile U2U Member Reply With Quote
ive got a spread sheet that i want to stay blank (ie no fill colour) unless when i enter text

for example when i enter text into field A1 i want the whole row to go red unless it has text in which i then want to go green

had a look on the excel forums but not sure how to do it, any ideas ?

[Edited on 22-09-2009 by jr]
pow
Premium Member

Avatar

Registered: 11th Sep 06
Location: Hazlemere, Buckinghamshire
User status: Offline
22nd Sep 09 at 20:08   View Garage View User's Profile U2U Member Reply With Quote
are you on MSN jr?

Sure its something I could help you with.

 
New Topic
New Poll

  Related Threads Author Forum Replies Views Last Post
Any MS Excel experts Steve Geek Day 11 1274
4th Jun 04 at 14:19
by blebo		  
is there a program that...... chris_uk Geek Day 6 1879
16th Jun 05 at 00:47
by Dan B		  
Microsoft Excel Kathryn W Geek Day 7 1252
3rd Aug 07 at 12:12
by RyanSxi		  
need an excel like programme (for free) Shane Geek Day 12 1754
13th May 08 at 14:55
by pow		  
Excel Wizards Mad Moe Geek Day 6 733
2nd Jul 08 at 16:59
by jamesw		  

Corsa Sport » Message Board » Off Day » Geek Day » Excel conditonal formating - any ideas 29 database queries in 0.0106518 seconds