If i have something in block B2, i want something in block A2 to change to a
certain font and fill color. I.E. If it were to say 'A' in b2 then i want
it to be black font and a green fill in A2; and if it said 'B' in B2 i want
it to be black font with a red fill in A2.

is anyone able to help me with this or know where i can look?