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!