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.

"JLGWhiz" wrote:

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" wrote in message
...
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.