Color row in range if any cell of that range is value

Hi all,

I need macro to color the rows in range O3:W100 if any cell of that row is value.
I've a problem. I can't use Conditional Format to do that because I'm using other macro witch is not recognizing colors from Conditional Format.
Any help?

I've that so far:

Please Login or Register  to view this content.

It does change the color but only the only cell its entered and I need to highlight the row in that range of cell was entered.

Looks better but now its highlighting all the row and I need to highligt the row only in range O:W.
So I think that part

Please Login or Register  to view this content.

has to be changed some how to select not EntireRow but just the range O:W.

Thanks john55,
Im nearly there ;-)
The problem with last code is that clearing my colors from the rest of columns and this is not what I want ;-(.
Is it not possible to change something here to specify the range in EntireRow instead of coloring and clearing the rest?

Please Login or Register  to view this content.