Hello

I've created the attached Gantt chart.

The conditional formatting gives all results in pink as a cell fill colour.



My question is:
How do I get the formatting to give a fill colour to be Green when Cells B10 to B29 are selected as Low, Orange when Cells B10 to B29 are selected as Medium, and Red when Cells B10 to B29 are selected as High?

Thank you

Attached Files

Gantt Cells Test.xlsx (20.3 KB, 13 views)

Like this?

Attached Files

Gantt.xlsx (25.7 KB, 15 views)

Yes!

Thanks so much. I'll have a look at how you did that later.