CAN I MAKE THE COLOR OF SEVERAL CELLS WITHIN A ROW CHANGE BY CHANGING A
CHARACTER WITHIN ONE?
EXAMPLE: A4 WILL BE EITHER AN "H" OR A "C". IF A4 IS AN H, THEN A4, A2, A3
AND A5 WILL CHANGE COLOR. IF A4 IS A "C", THEN THEY WILL ALL CHANGE TO A
DIFFERENT COLOR.
SHOULD A4 BE BLANK, THEN NO COLOR WOULD BE DISPLAYED.