Change cell text based on another cell's color

Closed
CarmelS - 16 Mar 2017 à 07:28
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 16 Mar 2017 à 10:10
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?


Related:

1 response

Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
16 Mar 2017 à 10:10
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