Hi,
I am thinking of having arrow pointing to the current week by conditional formatting which i already highlighted (also by conditional formatting).
However, i seem cannot come up of how to get it done. Your comment/advise will be very much appreciated.
Regards,
sanlen
I dont think you can use icons that way - they dont allow the use of formulas.
On a side note, if you just use =WEEKNUM(E9) and then format Custom W0, it will still show as you want, but then you can still use the week number in calculations
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
have to use a helper row due to limits of icon sets CF
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
slight change to icon set rule
also taking on board Fdibbins custom number format
Hi,
See the file attached..
Cheers!
Deep Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks