I've got a nice little softball question for you Masters of Excel. I'm trying to create a macro that selects the cell with the smallest positive integer from a table (A1:L16), and fills the background of that cell with a light blue color. The goal is to then manually replace that value with text, and rerun the macro to then find the next smallest positive integer in the table. This seems to be a simple task but I have little VBA experience and can really only manipulate code that I can record first. This does not qualify in that regard (except for the background fill part.) Although, I do feel like I'm overlooking a simple solution.
Any help would be appreciated!
Bookmarks