Filling the cells by color following period between two datums.

[Topa2]

Please check the description in attached file for better understanding.

I have added logic function where I can change the status for example X (instead of OK) and the cell in the same line and the same column will change from OK to X.

I would like to keep it as it is but I would like to mark with the same status and color the date from start what in this case is 10.01.2017 till the end 12.01.2017 (look the example in the line 7- (3 cells marked with green color and written condition OK as the date 10.01.2017 + 11.01.2017 + 12.01.2017.

The solution should be applycable for all table and simply adjustable if possible in case of any future modification.

Thank you

[AlphaFrog]

Not sure I understand what you are asking.

If you just want to turn the background color to green for all the "OK" cells, use Conditional Formatting (link)

• Select cell K7:BJ58
• change the background fill color to grey
• Select from the menu Format\Cells\Conditional Formatting
  - Condition Cell value = "OK" and set the background for green.

[Topa2]

In the file if you will change is Starting date and End date. Between those two days is always an period for example of two days like from 10.01.2017 till the end 12.01.2017.
So I suppose that I should have a function which will check the starting date for example 10.01.2017 mark it by green color as it is now in my file, but also will mark by the same condition the days between what means 11.01.2017 and 12.01.2017.

Once the action is done I will simply change the status for OK and all three cells will be in green. If the status will be in delay I will change the status on X and the three cells (the same cells) will become to red.

I hope that now you can see what I´m searching for.

Thank you

[AlphaFrog]

Yes. Conditional Formatting would do that
Tutorial: http://www.contextures.com/xlCondFormat01.html

[Topa2]

Yes I understand what you have done and this is good.
But I need something what will check the starting date and end date and after that will transfer the status + color to all the cells between both dates including this date automaticaly. I do not want to do it manualy because it is waste of time

[AlphaFrog]

Put this formula in K7 and copy it across and down the table.

=IF(AND(K$5>=$I7, K$5<=$J7),$H7,"")

[Topa2]

It´s works pretty well.
Thank you!

Have a nice day

Regards

[AlphaFrog]

You're welcome.

Your table is called a Conditional Formatting Gantt Chart if you ever need to ask someone for help again or do an internet search.

[Topa2]

Thank you.
I was not aware that there is exmplanation how to do the Gantt Chart in Excel . Good to know