I am a beginner so if there is an easy way to do this without VB let me know.

here is the cell forumla so far

=IF('Roster'!C2=""," ",'Roster'!C2)
if its null, put a space (gets rid of zeros) otherwise copy the cell
now....

if the text in C2 is
STR turn this row green
LTR blue
SGE red

(the row i want to change is the one that is copying not being copied)

please help ! =) hope it makes sense
mdpx