Hi there all!
I'm trying to change background colors if certain conditions are met but because conditional formatting allows only 3 conditions I am not getting the results I would like to. This is my problem: I have a figure in column G and then certain figures in K, L, M and N. I need to have ONE of the cells in K,L,M or N to change to a certain color if (1) G >= K; (2) G < L; (3) G <= M; (4) G > M; (5) G < N and then (6) G >= N.
I do not know anything about VBA and understand that there might be an easier way using it instead of excel (?).
Is there anyone out there who could help me please?
Thank you.
Rennier
I'm trying to change background colors if certain conditions are met but because conditional formatting allows only 3 conditions I am not getting the results I would like to. This is my problem: I have a figure in column G and then certain figures in K, L, M and N. I need to have ONE of the cells in K,L,M or N to change to a certain color if (1) G >= K; (2) G < L; (3) G <= M; (4) G > M; (5) G < N and then (6) G >= N.
I do not know anything about VBA and understand that there might be an easier way using it instead of excel (?).
Is there anyone out there who could help me please?
Thank you.
Rennier