I have 2 sheets. The first one has 2 columns:
- A:A - sequential numbers from 1 to 100
- B:B - 1-5 value for each number in A
Another sheet has matrix 10x10 from 1 to 100 where I would like to make conditional formatting by defining by the value from Sheet1!B. For example on the Sheet2 there will be number 55. Then I need to go Sheet1, find value 55 in column A and then based on the value in column B decide what formatting to apply.
