Coloring Cells

[Ron2490]

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]

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.