Hi All,
I am trying to pull together a macro which will format the data I pull from our system to save me from doing it manually.
It is almost at the point where I can run the macro and it will spit out exactly what I want. However, there's one step which is frustrating me slightly. The below macro is supposed to add a conditional formatting to a range of cells to highlight them Red, Orange or Green depending on their aging.
At the moment this works, but I have to select a range to apply the formula to, and the number of the rows in the report is not static (it will be different every month). Is there any way that instead of inputting a range manually I can get the macro to apply the conditional formatting to the bottom of the data?
I've highlighted the line in bold below which I think would need to be updated. Any help would be greatly appreciated.
Thanks!
----------------------------------
Bookmarks