Log in

View Full Version : Excel calendar repeat event every 4 day


Pajoooo
Apr 13, 2010, 01:44 PM
I need formula to repeat event every 4 day in Excel calendar, starting 03.04.2010.

Thanks

JBeaucaire
Apr 13, 2010, 04:43 PM
Got a workbook to look at? I can't visualize what you're doing without it.

Pajoooo
Apr 14, 2010, 01:39 AM
Try this,

Thanks

JBeaucaire
Apr 14, 2010, 10:42 AM
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.

Pajoooo
Apr 14, 2010, 02:59 PM
Sorry, my fault. Here's a file in xlsx format. Please help.

Thanks

JBeaucaire
Apr 14, 2010, 03:03 PM
I don't use Excel 2007, sorry. I can read the files, but I can't make use of any of those new features.

Pajoooo
Apr 16, 2010, 03:52 AM
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.

ScottGem
Apr 16, 2010, 04:09 AM
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.

JBeaucaire
Apr 16, 2010, 12:38 PM
... plus the two conditions he already has present.

Pajoooo
Apr 19, 2010, 01:37 PM
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.