I need formula to repeat event every 4 day in Excel calendar, starting 03.04.2010.

Thanks

Got a workbook to look at? I can't visualize what you're doing without it.

Try this,

Thanks

In Excel 2003 you only get 3 conditional formatting rules. You would need 6 to pull this off.

I don't use it, but in Excel 2007 I believe you can apply as many conditional formatting rules as you want.

Sorry, my fault. Here's a file in xlsx format. Please help.

Thanks

I don't use Excel 2007, sorry. I can read the files, but I can't make use of any of those new features.

Quote:

---

In Excel 2003 you only get 3 conditional formatting rules. You would need 6 to pull this off.

---

Which 6, show me, PLEASE, and I will add them in Excel 2007.

I haven't tested this, but why not try taking the difference between the date in the cell and your start date. Then dividing by 4 and returning the MOD value. The result should be either 0,1,2 or 3. Then create 4 conditions for each value.

... plus the two conditions he already has present.

RESOLVED!

For JBeaucaire,
I don't know did you see all six conditions in EXcel 2003, and send them in another file.

Thanks for the advice.