linked formatting

[Biocellguy]

Is it possible to have a conditional format occur if a linked cell is
highlighted?

Thank you

 

[Dave Peterson]

Nothing built into excel allows you to do this.

Is it possible to have a conditional format occur if a linked cell is
highlighted?

Thank you

 

[Biocellguy]

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}.â€

 

[Dave Peterson]

Nothing built into excel.

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.