For both of the following, I'm assuming that the word "week" (or "Week")
followed by a single space precedes your weeknumber/year as shown in your
sample. If that is not the actual case, you will have to adjust the
MID(A3,6,5) section in both of the formulas offered below.
1) To create your moving "arrow", select all of Row 2 and then select
Format/Cells from Excel's menu bar. On the dialog box that appears, click
the Alignment tab and select Center from the Horizontal drop down under the
Text Alignment section; then click the Font tab and select Marlett for the
Font, Bold from the Font Style list and 12 from the Size list. Click the OK
button when done. Now, put this formula in A2...
=IF(MID(A3,6,5)=WEEKNUM(TODAY())&TEXT(TODAY(),"\/yy"),"u","")
and copy it across. Is that what you are looking for?
2) Just to give you the choice, you can also make the "Week 15/08" text Bold
as well as highlight the cell containing it with a color. Select all of Row
3 and click Format/Conditional Formatting on Excel's menu bar. Select
"Formula Is" from the first drop down and put this formula in the next field
over...
=MID(A3,6,5)=(1+INT((TODAY()-(DATE(YEAR(TODAY()),1,2)-WEEKDAY(DATE(YEAR(TODAY()),1,1))))/7))&TEXT(TODAY(),"\/yy")
Now, click the Format button and click on the Font tab. Select Bold from the
Font Style list. Next, click the Patterns tab and pick a light (pale) color
from the color chart. Finally, OK your way back to the worksheet.
Rick
