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