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

Report
-
Posts
1921
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 13, 2021
-
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
1921
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 13, 2021
143
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!