M
MM User
Hi,
I have in column A options: a,b,c or d
depending on what is chosen is it possible change the background color of
the relevant row in B and C?
i.e. if a3 = a then b3 & d3 background is red or
if a3 = b then b3 & d3 background is green etc
If possible is it possible to do this automatically i.e. not run a macro
just on a cell change in A?
Thanks!
I have in column A options: a,b,c or d
depending on what is chosen is it possible change the background color of
the relevant row in B and C?
i.e. if a3 = a then b3 & d3 background is red or
if a3 = b then b3 & d3 background is green etc
If possible is it possible to do this automatically i.e. not run a macro
just on a cell change in A?
Thanks!