Hide rows based on conditional formatting cell backcolor?

[kbleo]

Hi

In my worksheet I have a column where user enters percentages. It represents the percentage the user spends on a various tasks. I have applied conditional formatting to this column so that all the cells in the column turns to red if a value has been entered in any of the cells in the column, but the total of the percentages is not 100%. The normal backcolor of the cells is a light blue. A further conditional format is that the backcolor of unused cells in that column must turn grey as soon as the total percentage entered is 100%.
This works fine. A further requirement now is to have a form button to hide all the rows which contain cells which have the grey color as done by the conditional formatting. I am trying the following code:

Please Login or Register  to view this content.

The problem is that it does not seem to work for backcolor that was set by conditional formatting. When I manually change the backcolor of a cell to the grey color then the row gets hidden when I run the macro.

Can anyone give me some advice?

Kind regards.
KB

[:) Sixthsense :)]

For you info CF formatting is not the actual cell formatting.

CF formatting is just for Visibility and it wont change the cells formatting.

If you remove the CF then you will get actual formatting of the Cell (Set Manually).

So instead of trying to use CF formatting use the CF Logic which you used to format the cells in your code to do the desired task