Linking cells to auto fill a color

[MarcM21]

Hi all,

I have a problem I was hoping someone could help with.

In column A i have a start date, and column B is an end date.

The next 52 columns are titled week1, week 2, etc....

I need to set it up so that when someone puts a start and end date in, excel will auto fill the corresponding weeks with a color. Is this possible or does anyone have an answer? Thanks!

[efernandes67]

I have attached a file.

I created "sDate", "eDate" and "wk1 .... wk53"!
I configured two rules in "conditional formatting".

Now, if you enter a date in A4 or B4 nothing is going to happen unless you copy the cell format from "wk1 .... wk53" in a previous row to the new one.

Elio Fernandes