Even or odd week?

[Ago]

background information:
my salary is different if its a even or odd week.
i have made a sheet that calculates my salary depending on what week it is.
i use the sheet in my cellphone so that i can find it easily.

problem:
i always forget if its a odd or even week.


is there a way make the software mark/change colour/bold... or something the salary i have that week.

my phone is a sonyericsson P1i, the officesoftware has the normal functions as excel does. ( now(), if, or, and, day... and so on.)
but i dont think it supports VBA

i tried finding a solution but it seems you need a addin to get that working, and i dont think i can install that either.

[Bob Phillips]

I bet it doesn't support conditional formatting does it?

If so you could use CF with


=MOD(WEEKNUM(TODAY()),2)=1

[Ago]

cant find conditional formating.
and the function weeknum doesnt exist either.
:-(

[david000]

=ISODD(A1-WEEKDAY(A1,3)) or =ISEVEN(A1-WEEKDAY(A1,3))

[mdmackillop]

cant find conditional formating.
and the function weeknum doesnt exist either.
:-(
You'll need the Analysis Toolpak from the add-in list