THIS DATA IS BASICALLY IDENTIFYING CORRECT CHOICES (A, B, C D)
I have a data as below in two sheets (Sheet1 & Sheet2). I need to compare or validate the cell value in both sheets and if the values are same based on the condition, then color the cell in Sheet1. The condition is, in Sheet2, get the cell value of A1 (ie.1) and then get the adjacent cell value next to cell A1, B1 (ie.A). Now if 1=A, then in Sheet1, look for 1 and A in colA and then color the cell which has value A. Simliarly repeat for all cell values in sheet2.
As per data shown below, based on Sheet2, 1=B, 2=D, 3=C. Then in Sheet1, in ColC, for 1, Cell value B must be colored in GREEN color, for 2, Cell value D must be colored in GREEN color, for 3, Cell value C must be colored in GREEN color,
Data as shown below:
Sheet1 Sheet2
ColC ColA ColB
1 1 B
A 2 D
B 3 C
C
D
2
A
B
C
D
3
A
B
C
D