Arrow Icon

[Joseph Horling]

Hi Chandoo Experts,
I'm working on conditional formatting on a chart. On the Index and Match tab, on row 29, there is a chart where I am practicing my two way lookup with index and match. First can you check and see if I did some of this correct. Second on the conditional format when you select the channel (highlighted in green on the chart), I would like to have an arrow pointing to the program and total views when the channel is highlighted. Thanks for your help as always, Joe from Michigan

 

[Hui]

Do you mean like



A34: =IF(B34=$C$30,"ð","")
Format it as WingDings
Copy down

 

[Joseph Horling]

Hi Hui,

Something like this:::

 

[Hui]

I'm pretty sure you can't do this with Conditional Formatting
You could use VBA to place the arrows, but I'd question why when my previous solution works fine

 

[Hui]

Or use the technique I used before with a helper column

 

[Joseph Horling]

Hi Hui,
Yes, that is fine. VBA is a little bit out of my realm there. Now I know how to do this part, thanks as always. Joe.