For Each..Next loop

[William Poh Ben]

I have been trying over the last 2 days without success. Hope to get help from you smart and kind people here.

Basically i want to fill in colors on the Accuracy %. For this example, I must type "H" when was asked for the column letter in the InputBox. If Accuracy is >10%, fill the cell YELLOW, if Accuracy is <-10%, fill the cell RED, and if it is between -10% and 10%, fill the cell GREEN. The code loops through from row 5 to last row, and repeats the same thing for all the sheets that look like certain characters.

I have manually placed the colors in the cells in the sheets as what they should exactly look like. When I run the command button, Sheets"FEP(GVD)") looks almost all correct except for cell H10, but the rest of the sheets had the colors quite haphazardly mixed up. Tried tirelessly to fix the bug but not getting me any where better. I would be most thankful on any help giving here.

Please Login or Register  to view this content.

[royUK]

Why not use Conditional Formatting?

[Andy Pope]

You missed a dot from a cells reference, which meant the active sheet was being used for the measure

Please Login or Register  to view this content.

As Roy says CF would do this.

[William Poh Ben]

Thanks so much Andy, and thanks too Roy.

I had tried with Conditonal Formatting, but the problem is when I used a UDF to count the number of different colored cells, it doesnt work. When I manually placed colors in the cells, the UDF's count then works. That's why I thought of using a procedure to fill the colors.