Every 28 days

Steved · Sep 22, 2005

Hello from Steved
Is this possible please.

Feb the 4th then every calendar days colour the cell red so in this instance
March the 4th being the 28th day the cell will change to a red background.

Thankyou.

Bob Phillips · Sep 23, 2005

Conditional formatting, with a formula of

=MOD(A2-DATE(2005,2,4),28)=0

Steved · Sep 23, 2005

Hello Bob from Steved

Thanks 1 situation is that it has done the 28 days as instructed
but it has highlihted a row above with this formula in it
=DATE(YEAR(L3),MONTH(L3)+1,DAY(L3))

I not to concerned but just curious as to why

Thankyou.

Bob Phillips · Sep 23, 2005

Because it is exactly 28 days later perhaps?

Steved · Sep 24, 2005

Yes thanks Bob

Bob Phillips said:
Because it is exactly 28 days later perhaps?