Text Format

[Phil]

Is there a way to highlight certain text or numbers in a column using
a formula? For instance, say, Column A has random numbers and I want
to highlight all the number 1 in that column red.

thanks

 

[Frank Kabel]

Hi
use 'Format - Conditional Format' for this. See:
http://www.contextures.com/xlCondFormat01.html
http://www.cpearson.com/excel/cformatting.htm