Thanks to the linked cell property in Microsoft Excel, it's super easy to use the selected value as a condition in a macro or conditional formatting rule.

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.

I'm attempting to connect to an excel file using an ADO recordset. There is a column in this that I need the sum of for a report. I'm familiar with ADO connections, so I assumed this would be the ...