S
SandyB
I have a column in which each cell has the option to contain one of six
different words. Based on which word is selected, I need 2 to 3 other cells
in the same row to change to a yellow highlight.
For example, if cell C2 contains the word flat, then I need cells H2 and I2
to become yellow.
But, If cell C2 contains the word 2FC, then I2, J2 and L2 need to be yellow.
different words. Based on which word is selected, I need 2 to 3 other cells
in the same row to change to a yellow highlight.
For example, if cell C2 contains the word flat, then I need cells H2 and I2
to become yellow.
But, If cell C2 contains the word 2FC, then I2, J2 and L2 need to be yellow.