Share via

How can I move a shape based on date in Excel

Anonymous
2023-06-15T12:44:57+00:00

Hoping someone can help - but I am looking to find a way of automatically placing a shape over the current date on a gaant chart?

Image below

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2023-06-18T01:22:05+00:00

    Try selecting the shape, right-clicking, and changing its properties

    Image

    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-06-15T13:13:15+00:00

    Hi there

    If the shape you want to move is not linked to any macro, I would suggest using conditional formatting rules for the range of cells

    Per example you may highlight today's data cell in Yellow while the remaining cells keep the black color background you selected.

    Regards

    Jeovany

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2023-06-15T14:09:12+00:00

    The problem there is that I need the text to span multiple columns. Like below

    0 comments