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

Report
-
Posts
1842
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 27, 2020
-
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

Posts
1842
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 27, 2020
136
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