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 =$A5$=100%Format color yellowok. When A5 is = 100% 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 formatting to following 200 rows, where the original
text and values don't change?

With format brush I tried but no result.
With CTRL+D also no result.
I desire those rows which have 100% value in the relevant cell changes the
color not the entire sheet at once.

If there is no other way to fulfill this CF, please instruct me by Macro
VAB. But explain it in detail as I am not professional in Macro.


Thanks Iraj.