You might also consider using Data Validation.
For example, assume the cell you have for this value is A4, go to menu
Data--Validation
Choose Custom under the Allow pull down
Then in criteria type the following formula:
=OR(A4=0.5,A4=0.25)

Note: If you have a range of cells for this, it is just as easy, select your
range, and type the above formula, substituting whichever cell is the
'active' cell in the selected range. (It will be the one that is not shaded
but is in the range). So long as you don't anchor the cell reference with $,
then it will change itself as needed.

--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"Raz" wrote:

I would like to have a conditional formulla, so that only .25 or .5
(Numbers) can be typed in a cell. If anything else is typed the cell color
should turn red.