Hi,

I want to loop through a range of cells starting at D5 and then going as far
to the right and down the spreadsheet as there are values in the sheet.

For each cell I want to be able to color code the background of the cells
depending upon the following criteria

Cell contains 0h Cell colour is white
Cell contains >0h but less than 8h Cell colour is Yellow
Cell contains 8h Cell colour is Orange
Cell contains greated than 8h Cell colour is Red

But I also want to ignore the cells in the last two rows and the farthest
populated column of the spreadsheet as

The spreadhseet can be a different size each time it is generated so the
code must accomodate this.

I am sure this is fairly straight forward but I'm a bit of a newbie to this,
so was hoing someone could help me out here.

Many Thanks

Regards

Ian