I have an excel spreadsheet set up with columns for date, name, check#, etc.
To enter the information more efficiently as there is too many would be
the data -table...correct?

Then in each row the font is colored for example pre...is green....post is
red....
mixed is blue. So I was thinking of adding another column, so it would
become
part of the table to enter data. If I entered pre in there, how could I get
it
to change all data to say green?

I'm open to any suggestions!!

Thanks