Creating a Hyperlink to Trigger Conditional Formatting
Hi, I would like to create a hyperlink, so that when I click on the hyperlink, it triggers a conditional formatting where the cells that contain the hyperlinked word will change colour. For example, If I wrote the word “Test” in cell D21, and I click on the word “Test” in D21, it should make all the cells from D8:G16 that contain the word “Test” to change colour. Is this possible without VBA?
Hi, I would like to create a hyperlink, so that when I click on the hyperlink, it triggers a conditional formatting where the cells that contain the hyperlinked word will change colour. For example, If I wrote the word “Test” in cell D21, and I click on the word “Test” in D21, it should make all the cells from D8:G16 that contain the word “Test” to change colour. Is this possible without VBA? Read More
