I'm creating a utility in Excel that takes mesh bad leveling raw data (49 values, 7x7 grid, with the center value being what all other values are being compared to). Some values are positive, some ...

When creating Microsoft Excel formulas, you can generate calculations using specific values—also known as hard-coding—or referencing other cells in the workbook.

When you think VBA code is your only hope, try combing built-it conditional formatting tools. You might just find an easier solution than writing code.