Moving of grey column following today date in timing plan

Hi,

I have a function which is checking start date and end date for activity and following this two dates is coloring the cells in the timing plan (have a look for attached file).
Anyway I would like to modify the function (if possible) and everyday to change column following today date. As you can see I have colored the column O by greay color because today is 13.01/.017. At Monday will be 16.01.2017 so I would like that on Monday the grey column will on column R.

The function used in english is =IF(AND(K$5>=$I7, K$5<=$J7),$H7,"")

Thank you

Select K5:NC58
input =K$5=TODAY into Conditional Formatting

Thank you sandy.
Now itīs work

You should use Conditional Formatting for this. First of all, you should remove the (manual) colour that you have applied, and then select all the cells first, so that you only have to do this once to set it up, i.e. from K5 to NC58. Then click on Conditional Formatting | New Rule | Use a Formula... , then put this formula in the dialogue box:

=K$5=TODAY()

Click the Format button | Fill tab and choose the shade of grey that you want, then OK twice to exit the dialogue box. Excel will automatically adjust the cell references to suit the cells that were selected.

Hope this helps.

Pete

Hi Pete,

Thankīs for your detailed instruction. With description like this there is no way to not do it right .

If problem is resolved add reputation star to person(s) who helped you and mark thread as solved. Thank you

Thanks for the rep, Topa - glad to have helped.

Pete