Conditional Formatting using Offset (Gantt Chart)

[MixedUpExcel]

Hi,

I'm trying to put together a Gantt Chart using Conditional Formatting.

Column A has numbers 1 to 50, starting in Cell A3 to Cell A53
Row 2 has Week 1, Week 2 etc from Cell B2 to Cell BA2

I will have formula's in the chart which will either put the word Start or the word End (based on data from another sheet).

I would like to set Conditional Formatting to find the Word Start and then highlight all cells to the right until it finds the word End.

I tried what I thought was logical but it's not showing any results:

=OFFSET(A3,0,match("START",A3:BA3,0),1,match("END",A3:BA3,0)-match("START",A3:BA3,0))

With the Range: =$B$3:$FA$3

What am I doing wrong?

Thanks.

Simon

 

[MixedUpExcel]

This has now been solved.. No longer using Offset as I understand that Conditional Formatting only works if a condition is TRUE.