I have a workbook and what I have been using to highlight cells is Conditional Formatting. The issue I have now is when I copy this to another sheet with other data the conditional formatting is conflicting with other items on that new sheet so I need to get away from that and just use highlighting in its basic form.
What I want to do is the following:
Column X through Column AF any cell within these columns with a value of greater than zero I want to highlight orange.
This will be from Row 2 to last Row in Each column. (Each column has the same number of rows).
In my macro I currently have a last row variable as "lrow = Cells(Rows.Count, "B").End(xlUp).Row"
I thank you in advance for your assistance.
What I want to do is the following:
Column X through Column AF any cell within these columns with a value of greater than zero I want to highlight orange.
This will be from Row 2 to last Row in Each column. (Each column has the same number of rows).
In my macro I currently have a last row variable as "lrow = Cells(Rows.Count, "B").End(xlUp).Row"
I thank you in advance for your assistance.