I have a list of text and values i.e A5:M5 and 200 rows beneath. I
highlighted A5:M5CFNew ruleUse a formula to determine which cells to
format =$A$5=10%Format color yellowok. 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.