Hello,
I am trying to design a macro that will look at a text input in one cell, and then highlight a different range of cells in a column.
For example:
When A1 = x, A5:A25 will highlight in red
I would then like to replicate this for other columns in a similar fashion (eg: When B1 = x, B5:B25 will highlight in red)
I can accomplish this through the conditional formatting wizard, but unfortunately I need a macro for this job (because I will run the macro each week on a new spreadsheet).
Many thanks for any help!
Bookmarks