Removing Colour From Empty Cells

Hi,

I have code that colours cells based on their values. But i'm using a loop and it's colouring blank cells within the loop.

here is the code:

Please Login or Register  to view this content.

The last two statements are commented out at the moment (was my approach to remove the colour). Right now the code colors cells that are either 0 or empty cells up to row 750 with the colour I used to colour the cells with the value of 0.

Beyond row 750 the cells are white again, not sure how to go about removing the colour of the empty cells before that. I also tried the IsNumeric() for my = 0 statement.

Any help is greatly appreciated.

Thanks,
Jermal

Hi Jermal, try

Please Login or Register  to view this content.

I think you need to upload a mock copy of your workbook so that we can see your reference to example 575 to 750. The way it is now, I am just guessing.

Hi Jermal, sometimes baby steps are needed, hopefully we are a step in the right direction now. Compare the following code with yours and noticed the lines that I commented out

Please Login or Register  to view this content.

Also, if you want the "Task Estimated Hours" and "% Completed" columns to have the same colors in their interiors, use

Please Login or Register  to view this content.

You are welcome!