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. |
data change color automatically
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. |
data change color automatically
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. |
All times are GMT +1. The time now is 02:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com