Hi all
My question is more a general issue i've been having.
for a group of 200 entries I have applied conditional formatting.
The issue I'm having is that I am continually adding new entries to this list, and simply copy and pasting the formats does not work well.

If I have the following listed in my conditional formatting: =IF($E4=$F$2,TRUE,FALSE)
applied to cells =$D$4:$F$271
and I add 5 new entries, and copy and paste the formats from an old row to the new row, I do not want to add new conditional formatting
I simply want the current conditional formatting to now apply to cells =$d$4:$f$276
The way i am currently copy and pasting formatting for new entries I can go from 1 conditional format to 15 in a matter of days, as new conditional formatting parameters are added with each new entry.

If i am not being clear, i apologize...
Thanks for any assistance!