Hi...I have for example a column a1..a20 containing 6 digit chassis numbers, all can shuffle up or down in the column depending on various sort options in the spreadsheet. Column c1..c20 contain the some of the same chassis numbers but in a fixed position (they are sourced from a different workbook). In column D1..D20 is a number which can be either 1,2 or 3.
What I am trying to achieve is the chassis number in, for example, cell A2 might have a corresponding identical chassis number in, for example, cell C10 Conditional formatting would then use the contents of D10 (either 1,2 or 3) to change the fill colour of A2.
I do hope that makes sense and any guidance would be gratefully received.
Bookmarks