Change cell text based on another cell's color

Closed
CarmelS - Mar 16, 2017 at 07:28 AM
Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 - 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?


1 reply

Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 146
Mar 16, 2017 at 10:10 AM
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
0