Jun 22, 2004 #1 gc1234 Programmer Mar 4, 2004 94 GB Hi all, Just wondered if its possible to put text in a cell when a row is changed to a certain colour>? gc
Hi all, Just wondered if its possible to put text in a cell when a row is changed to a certain colour>? gc
Jun 22, 2004 #2 S SkipVought Programmer Dec 4, 2001 47,492 US Hi, No, but you can change the Interior COLOR of a cell when a VALUE changes to a certain text. However, it can be done with VBAm if you want to pursue that. And THAT depends on what makes the Interior Color or the row change. Skip, Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244 Upvote 0 Downvote
Hi, No, but you can change the Interior COLOR of a cell when a VALUE changes to a certain text. However, it can be done with VBAm if you want to pursue that. And THAT depends on what makes the Interior Color or the row change. Skip, Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244