ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Changing Feild Color via value (https://www.excelbanter.com/excel-programming/333749-changing-feild-color-via-value.html)

jnorton

Changing Feild Color via value
 
I would like to change the feild color if a certain value is reached

=IF(C24=255,"Red","Blue")

this places the text in the feild but I would really like to change the
color of the field itself.

Anne Troy[_2_]

Changing Feild Color via value
 
Do this with a formula in Format--Conditional format.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"jnorton" wrote in message
...
I would like to change the feild color if a certain value is reached

=IF(C24=255,"Red","Blue")

this places the text in the feild but I would really like to change the
color of the field itself.





All times are GMT +1. The time now is 10:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com