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.