So it is not possible to have an equation that basically says “if Cell A1 is
{select color} display {select color 2} if not then {select color 3 or no
color}.â€
You could build your own user defined macro that does pretty much whatever you
want. But even then, it may not work the way you want. Changing a color of a
cell doesn't make excel recalculate.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.