conditional formatting updated by vba

hi
can you update conditional formatting in vba,sheet4 has conditional formatting highlighting rows using a textbox,if i add another say 10 rows it only looks up the original settings,have tried to increase number of rows but does not work or i can not get it to work,would like it to after i enter new data to extend its search and when entering a st number look through all sheet4,is this possible,as usual any help would be good
thanks
cheers colin

I don't quite understand what you're up to (I deleted your formats ); but, assuming you want to highlight rows where Column A value is equal to textbox value:
1. I created a named range on sheet four that will update when rows are added.:

Formula:

=OFFSET(Sheet4!$A$2,0,0,COUNTA(Sheet4!$A:$A),13)

2. With A3:M27 selected applied formula

Formula:

=$A3=$Q$2

and entered "=sheet4id" in the applies to box