Change cell text based on another cell's color [Closed]

CarmelS - Mar 16, 2017 at 07:28 AM - Latest reply: Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen
- Mar 16, 2017 at 10:10 AM
Hello,

I need to prompt a cell to write text based on another's cell color in excel but not using VB. Can you help?


See more 

1 reply

Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Mar 16, 2017 at 10:10 AM
0
Thank you
CarmelS, Good morning.

If the color of another cell is based on a Conditional Format you can manage that formula to act like that.

BUT, iIf the color was placed manually I believe that only with VBA Code is it possible.

I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão