Conditional Format Paste

[Kindlysinful]

Hello all,

I have a reoccurring spreadsheet that when I copy and
paste special all of the formulas will convert to whatever
cells that they need to convert to, however, the
conditional formatting that I put in will not convert.
Ie; if the value in a1 is greater than 100 then the font
is green.
What I need it to do is when the spreadsheet is pasted
into a2 I need it to be if the value in a2 is greater than
100 then the font is green. But what it does is say if the
value in a1 is greater then green font????????
Any and all help will be greatly appreciated.

 

[Frank Kabel]

Hi
for cell A1 enter the following formula within the conditiona format
dialog
=A1>100

now you can copy this format to cell A2