Changing programmatically the color of a row

[masterx81]

Thanks, it has worked!!!

But whot is the 1 after the $A ?

very thanks

 

[Frank Kabel]

Hi
this is the first row. I used a mixed absolute/relative reference.
check this if you go in a different cell and look at the formula in the
conditional format dialog