VBA - Highlight cell if greater or less than in dynamic range

[Maleko-1]

Hi there,
I can't find an answer to this in VBA.

Cell D5 has a value (upper limit) and cell D6 has a value (lower limit).
From D10 down to the end of data in column D are values that if falls outside of the upper and lower limit above I need the cell highlighted red.
Another catch is...I need the same scenario to happen in all other columns to the right that has data.
For example, E5 and E6 (upper and lower limits) and E10 down has the data and so on to the last column that has data.

If anyone can help me with this it would be so appreciated and I would forever be in debt to you.

Thank you
Marc

 

[BarryL]

conditional formatting would be best no? apply the below rule to D10:Z1000 or however many cols/rows you have


=OR(D10<D$6,D10>D$5)<d$6,d10><d$6,d10></d$6,d10></d$6,d10>

 

[BarryL]

=OR(D10<D$6,D10>D$5)

something wrong. this should be the rule

 

[BarryL]

=OR(D10 <D$6 ,D10 > D$5)

have to use spaces for some reason

 

[BarryL]

right this page has something wrong with it

OR(D10<D$6,D10>D$5)

 

[BarryL]

=OR(D10 less than symbol D$6,D10 greater than symbol D$5)

 

[Maleko-1]

Thanks for the reply, but I need to use VBA.
I would use conditional format except that the workbook is generated by a macro and every time the code is run a new workbook is created.

 

[BarryL]

Can't write the code from my phone but why not record the conditional formatting rule and add it to the code you have?

 

[Maleko-1]

I just don't know how to apply it to each column that has data.

 

[Maleko-1]

Still not having any luck. I know how to apply this to the first column I just don't know how to apply it to all the columns if they have data.