PC Review


Reply
Thread Tools Rate Thread

Coloring Cells

 
 
Ron2490
Guest
Posts: n/a
 
      2nd Aug 2010
I would like to color cells IE:yellow when a specific number appears
IE: 10 or 18 Is this possible (I would like for this to be done
automatically)

Thanks

Ron
 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      2nd Aug 2010
If you're not using too many numbers or not too many rules, you may be able to
use Conditional Formatting.

In xl2003 menus, you can find it under Format|Conditional Formatting.

Debra Dalgleish explains more:
http://contextures.com/xlCondFormat01.html

If you're using xl2007 or higher, the number of rules has been increased a lot.

On 08/02/2010 13:07, Ron2490 wrote:
> I would like to color cells IE:yellow when a specific number appears
> IE: 10 or 18 Is this possible (I would like for this to be done
> automatically)
>
> Thanks
>
> Ron


--
Dave Peterson
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
COLORING IN CELLS =?Utf-8?B?amltIG1jZ3JhdGg=?= Microsoft Excel Misc 4 24th Nov 2005 04:31 PM
Coloring certain cells =?Utf-8?B?VGlt?= Microsoft Excel Worksheet Functions 2 5th Sep 2005 04:01 AM
Coloring Cells Gabbi Microsoft Excel Worksheet Functions 2 27th Jul 2005 09:54 PM
Coloring cells Patrick Simonds Microsoft Excel Programming 2 25th Apr 2005 12:59 AM
Coloring cells Troy Microsoft Excel Worksheet Functions 1 8th Oct 2003 01:22 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:23 PM.