Add a callout at the end of the highlighted cells

Hi Guys,

I am creating a timeline where I use conditional formatting to highlight "TRUE" and "FALSE" values in rows to show the project timeline.
Whenever it says "TRUE" I highlight cells, "False" are conditioned in white font, so you can't see them.

I would like to insert a call-out textbox or a shape, with the end date of the project's phase.

For example, in my timeline row 9 has cells O9 and P9 highlighted in blue. Is there a way to insert a callout textbox (text H9) in the cell Q9? or perhaps P9? The idea is to call out the date when the phase ends.


Thank you guys! Will appreciate any help and thoughts!

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and click "manage attachments" to open the upload window.


To add a file to a post

Here's a code, it looks through the range and if the cell <> Fasle, then will add a textbox to the cell next to it. Then name the text box "Phase" & whatever row it is on.

There is an additional code you can use to delete the textboxes as well, usually.

Please Login or Register  to view this content.

I don't know what you mean by removing a shape from a textbox

Perhaps a small change to Dave's code

Please Login or Register  to view this content.

This should do it!!

Please Login or Register  to view this content.