Hi,
For work we often get a spreadsheet that for my use I need to filter and highlight certain columns.
For example one column has some cells that contain the word yes. I need to highlight every cell that says yes and also highlight another cell in that row.
So if row 5 has the word yes in column B both B5 and another cell in the row need to be highlighted (i.e. E5)
The document has a different amount of entries every week but usually around 1500 row.
I have tried a couple of different ways but I'm new to VBA.
For work we often get a spreadsheet that for my use I need to filter and highlight certain columns.
For example one column has some cells that contain the word yes. I need to highlight every cell that says yes and also highlight another cell in that row.
So if row 5 has the word yes in column B both B5 and another cell in the row need to be highlighted (i.e. E5)
The document has a different amount of entries every week but usually around 1500 row.
I have tried a couple of different ways but I'm new to VBA.