Your formula needs to be entered as a conditional format formula. To do
this:
1) Click on cell A1
2) Click the Format menu
3) Click "conditional Formatting
4) Change the condition from 'cell value is' to 'formula is'
5) Copy and paste the formula from the previous mail
6) Click the 'Format' button
7) Choose your formatting options
8) Click 'OK'

To learn more, try Debra Dalgleish's site
http://www.contextures.com/xlCondFormat01.html


"excelstart" <excelstart.21d5tb_1136803801.873@excelforum-nospam.com> wrote
in message news:excelstart.21d5tb_1136803801.873@excelforum-nospam.com...
>
> Confused, if I input the formula in the cell and copy it down the
> column, and then I try to fill in the data, the formulas are replaced
> with the text I type in.
>
> Is there any way of embedding the formula in the cells so that the
> formula is not affected by me typing the content?
>
> JP
>
>
> --
> excelstart
> ------------------------------------------------------------------------
> excelstart's Profile:
> http://www.excelforum.com/member.php...fo&userid=5881
> View this thread: http://www.excelforum.com/showthread...hreadid=499209
>