I have a spreadsheet that is refreshed periodically and the data range
changes each time. I want to apply conditional formatting to non-blank cells
in columns D, F and H. So I guess I need to identify the number of rows in
the range and then loop through each cell in each of columns D, F and H and
apply the formatting.

How can I do this?

Grateful for any help.