Hello,
I have in column A options: A,B,C or D maybe more later.
depending on what is chosen is it possible change the background color of
the relevant row going across from column A,B,C,D,E and F but not the whole
row.

i.e. if a value in column A2 down to A200 or more would equal either A,B,C
or D then the background color would automaticlly change to red for A, blue
for B, green for C and yellow for D, etc

If possible is it possible to do this automatically as I add more info and
do a sort?

Thanks!

Terry