Hi everybody,
I have a row with the days of the year 1,2,3,.....365. And I would like to highlight every 12th day (12, 24, 36, 48 .....) , or every X th day .
I have been struggling with this problem for hours now , I would appreciate your help .
Hi everybody,
I have a row with the days of the year 1,2,3,.....365. And I would like to highlight every 12th day (12, 24, 36, 48 .....) , or every X th day .
I have been struggling with this problem for hours now , I would appreciate your help .
try using the following formula for you conditional formating rule
=MOD(A$1,12)=0
Last edited by DGagnon; 03-19-2012 at 05:57 PM. Reason: Numbers in Row1, not Column A
If you liked my solution, please click on the Star -- to add to my reputation
If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.
Hi use this formula in CF
=MOD(A$1,12)=0
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
Yeah , I've been trying that already, but somehow it doesn't work . Is it possible to be because I have excel 2010 ?
make sure you highlight the entire row first, with A1 as the first selected value, then you should be good. unless by chance your values are actualy Date values instead of just numbers, in which case we would need to make a change to the formula as so:
=MOD(A$1-DATE(2012,1,1)+1,12)=0
The cell's are formatted as general, I tried formatting the cell as number but I had the same problem. I don't know what I'm doing wrong. Here's a video of what I'm doing, maybe you can figure out what I'm doing wrong.
http://www.youtube.com/watch?v=QayNz...ature=youtu.be
Thank you very much for your help !
Hi
Your problem is in 0:30 of this film (you have pasted the formula with the empty space " " on the end (You have copied this directly from forum with it)). Type it by hand or copy in proper way.
regards
have a look at the attached file, it should help you with this
Thanks very very much DGagnon, that did it !! It was a semi colon not a comma between A$1 and 12 :D !
The correct formula is =MOD(A$1;12)=0
Again, thank you very much !
ah yes, that is a regional setting, in canada/us we always use comma, where as i think alot of Europian countries use semi-colon. you will probably find that most solutions you find here will have a comma, and you can replace them with Semi Colon to make it work for you.
Good luck!
Please mark this thread as solved. If you don't know how to mark it as solved check out FAQ's.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks