ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   linked formatting (https://www.excelbanter.com/excel-worksheet-functions/150595-linked-formatting.html)

Biocellguy

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

Thank you

Dave Peterson

linked formatting
 
Nothing built into excel allows you to do this.

Biocellguy wrote:

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

Thank you


--

Dave Peterson

Biocellguy

linked formatting
 
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" wrote:

Nothing built into excel allows you to do this.

Biocellguy wrote:

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

Thank you


--

Dave Peterson


Dave Peterson

linked formatting
 
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.



Biocellguy wrote:

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" wrote:

Nothing built into excel allows you to do this.

Biocellguy wrote:

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

Thank you


--

Dave Peterson


--

Dave Peterson


All times are GMT +1. The time now is 10:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com