Change cell text based on another cell's color

Ask a question CarmelS - Last answered on Mar 16, 2017 at 10:10 AM by Mazzaropi

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

plus moins
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
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!