Conditional formatting dynamic range of cell (manual gantt chart)

[tom_tom]

As this is my first post I would like to say Hi to the community.

I have been looking for an answer for this for a while and conceeded.

I am looking for a conditional format idea between two range of unique cells, so everything between "START" and "Actual" in each row would be formatted and changing, depending on where the start and finish cells are.

Also, is there a possibility to include self-updating vertical bar showing actual time? Apologies, but I am speaking bit out of my depth here

[ChemistB]

Try this conditional formatting formula

Please Login or Register  to view this content.

I believe that is what you were looking for in part 1 of your question. I do not know what you are looking for in Part 2. It would help if you included in your example workbook, a manual representation of what you are looking for.

[tom_tom]

Hi ChemistB, much appreciated!

Looking at the formula now it makes perfect sense, but at the time I didn't have a clue where to start!

With regards to the second part of my question I have attached an amended sheet showing the bar.

[ChemistB]

Okay, if you're looking for a thin line like that, you'll need to use VBA to insert a shape. Probably best to start a new thread in the Programing/VBA/Macros forum.

To some extent, we can duplicate this with Conditional Formatting.
I inserted a row (which can be hidden) which contains the times at half hour intervals. I also did a table on Sheet2 where I added extra columns to put in 15 minute intervals thus slimming the line a bit.

Then I added this conditional Formatting like so

Please Login or Register  to view this content.

Checking "Stop if True"

[tom_tom]

Great, that'll do, thanks again!