Share via

Conditional Formatting

Anonymous
2017-09-28T11:39:32+00:00

Hi - I'm trying to amend a basic Gantt chart

I'd like the ability to select a week and for that weeks column to highlight.

I did have this facility originally but I've changed something by mistake and have totally lost the action.

I'm using the following formula: =I$5=period_selected 

This is the same formula as used on the original doc, but nothing happens - what am I doing wrong?

Thanks,

Kirstie

Microsoft 365 and Office | Excel | For home | 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

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-09-28T12:39:38+00:00

    Thanks Tom, turns out all i needed to do was to press return whilst in the formula - et

    voila!

    Here was me thinking that by clicking 'apply' that would action the formula - silly girl

    All sorted now - thanks

    Was this answer helpful?

    0 comments
  2. Anonymous
    2017-09-28T12:16:44+00:00

    You formula looks fine.

    So the next test would be to see if I$5 actually equals period_selected. 

    --

    Regards,

    Tom Ogilvy

    Was this answer helpful?

    0 comments