Copying a conditional formating rows with text and values

[Iraj]

I have a list of text and values i.e A5:M5 and 200 rows beneath. I
highlighted A5:M5>CF>New rule>Use a formula to determine which cells to
format> =$A$5=10%>Format color yellow>ok. When A5 is + 10% the A5:M5 will be
automatically yellow, but when I want to copy this format to the beneath rows
it will change all the original text and values. Is there any rule to copy
this conditional formating to following rows that original text and values
don't changes. With formatingbrush I tried but no result too.

Thanks Iraj.

 

[JLGWhiz]

You could select Range("A5:M205") and set the conditional format for all of
the at the same time. That way you would not have any copying to possibly
change the formats and contents of other cells in the range.

 

[Iraj]

But this kind of formating will change the whole sheets color by just any
cell value=10%. Where I want the specific rows which has 10% values to be
color formated and not the complete sheet at once. I have done all that I
thought it may help but no resul so far.
Thanks Iraj.