Thread: Every 28 days
View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

Conditional formatting, with a formula of

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

--
HTH

Bob Phillips

"Steved" wrote in message
...
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.