I have a macro that creates a workbook and adds data to sheet 1. The data range is always different with each new created workbook.
In each column with data starting from column D there are values in row 5 (upper tolerance) and values in row 6 (lower tolerance).
From row 10 down to the last row are values that if anyone of them is greater than the value in row 5 or less than the value in row 6 I would like to have the cell highlighted red.
This would apply to any column that has data as well.
I know where I will need to add the code I just don't know how to construct the code to do this.
I understand that this can be done using conditional formatting, but I really need to make this automated.
I have searched and actually posted this similar problem in another forum and not getting the results I need for doing this with VBA so I thought I would try here as well.
Here is the link:
Any help that you can give would be very appreciated.