Hi all, I have some questions on my work but i don't know how to solve it through vba. Please offer help.
for my case, from column A to AJ and row 1 to 10000.
two column are pairs like AB, CD, EF, GH......
1. They compare colors pairs by pairs like A10,B10, both of them are yellow, I want to to be one yellow in A10, also C15,D15, only yellow would be shown in C15.
2. If C8 is red, D8 is yellow, I want the box would be plain if they are in different colors.
3. the plain one keep plains.
I hope my poor presentation wont scare you. Thank you.
for my case, from column A to AJ and row 1 to 10000.
two column are pairs like AB, CD, EF, GH......
1. They compare colors pairs by pairs like A10,B10, both of them are yellow, I want to to be one yellow in A10, also C15,D15, only yellow would be shown in C15.
2. If C8 is red, D8 is yellow, I want the box would be plain if they are in different colors.
3. the plain one keep plains.
I hope my poor presentation wont scare you. Thank you.
