Macro Help!

[dmr5112]

I am try to write a macro that will highlight a row based on certain criteria in a cell. If column N values are greater than 5, and column O values are between 0 and 90, I would like the row to be highlighted in orange. I only want to row to light up if both these conditions are met.

I tried to use conditional formatting to achieve this, but because I copied and pasted values onto the worksheet, the particular conditional formatting I was using (=INDIRECT(“[COLUMN LETTER]”&ROW())=[VALUE]) would not work. I tested the formula out in a new workbook, and the formula worked fine, so that was how I deduced it was the copying and pasting problem.

Please help! I have been stuck on this problem for weeks!

[shg]

Welcome to the forum.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.