A
andrew
I hv the following table:
A B C D
XT A1 C3 A2
23 C3 C3 A2
13 A2 A1 C3
XT C3 A2 C3
Is there a formula to check column A for the specific text "XT", and then
color the row (A-D) with the color of choice? What happens is that the row is
incrementally updated with data every week, hence whenever a new row has
column A with the text "XT", it should automatically convert row cells of A-D
(where "XT" resides) into a color of choice. Possible?
A B C D
XT A1 C3 A2
23 C3 C3 A2
13 A2 A1 C3
XT C3 A2 C3
Is there a formula to check column A for the specific text "XT", and then
color the row (A-D) with the color of choice? What happens is that the row is
incrementally updated with data every week, hence whenever a new row has
column A with the text "XT", it should automatically convert row cells of A-D
(where "XT" resides) into a color of choice. Possible?