I have a spreadsheet matrix that is 128 by 128.
The matrix cells are linked to 128 worksheets within the workbook.
On the matrix worksheet, we would like to compare 2 cells. If they are equal, then no action is required. If they are not equal, then we need to use conditional formatting to highlight both cells.
We can not use the copy function within Excel. because we are comparing vertical column cells to horizontal rows cells. So it would require me to update all 16,000+ cells.
The macro needs to allow us to go down each column and then compare it to a cell that goes across a row.
Example: Compare (C2 & D1), (C3 & E1), C4 & F1). That process needs to occur for all the cells within the 128 by 128 matrix.
What would you estimate your costs and completion date.