On Tue, 27 Feb 2007 12:23:06 -0800, Tammy
wrote:

Is there a way (macro or vb code) to make a text appear a certain color. For
example, if the number in the cells a1:aa65000 50 but <50000 then color them
red?


Look at Conditional Formatting.

It can be invoked either directly from the Format menu in Excel, or used within
VBA.
--ron