I need formula to repeat event every 4 day in Excel calendar, starting 03.04.2010.
Thanks
![]() |
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.
Which 6, show me, PLEASE, and I will add them in Excel 2007.Quote:
In Excel 2003 you only get 3 conditional formatting rules. You would need 6 to pull this off.
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.
All times are GMT -7. The time now is 09:00 AM. |