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

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