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 FormatConditional 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 FormatConditional 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.