data change color automatically

i like to change the color of the data i key in automatically, eg. the
condition is "if data keyed in is less than 12.36 or more than 14.36, the
data is turning red color."
not sure it can be done or not. thx.

It can be done. Select the cell or cells you want to perform this on then
select Format>Conditional Formatting. Type the conditions in to boxes and
then select the format you want and that should do it.

Ian


"yetshin" wrote:

> i like to change the color of the data i key in automatically, eg. the
> condition is "if data keyed in is less than 12.36 or more than 14.36, the
> data is turning red color."
> not sure it can be done or not. thx.
>

yes, i have done it. thx very much!

Ian P wrote:
>It can be done. Select the cell or cells you want to perform this on then
>select Format>Conditional Formatting. Type the conditions in to boxes and
>then select the format you want and that should do it.
>
>Ian
>
>> i like to change the color of the data i key in automatically, eg. the
>> condition is "if data keyed in is less than 12.36 or more than 14.36, the
>> data is turning red color."
>> not sure it can be done or not. thx.