Need help color the current MONTH,WEEK and DAY

[grenbeach]

Hello!
I am Working on a calendar project for work.
I was wondering if there is possible to create a formula that automatic change the current Month, week and day as illustrated in the example file.
I have experimented alot using conditional formatting with no luck.

Thanks for the help!

[JohnTopley]

What are the CF rules? Green for current Month, Week number and Day?

It would be much better (easier) if the row 3 entries were Excel dates formatted as "D" rather just a number.

[grenbeach]

Yes, Green for current Month, week number and day. If possible. othervise i would be happy with just the current day displaying green color. But then i need to format my cells to date? or am i wrong?

The only reason why i am using just the number of the day in the month instead of a date is these small cells just show "##" when its to much text. I want my cells to be this small. So if it is a way to use date format and still be able to see the date it would be nice.

[JohnTopley]

If you enter the dates but format the cells as "d" you will just get the DAY value (1 to 31)

[JohnTopley]

With dates in ROw3:

Select row 3

in CF

=C3=TODAY()

FORMAT==>Fill==> Colour==>OK

[grenbeach]

Sweet! that did the job! Thanks alot
Do you have a solution for row 1 and 2?

Edit:
I changed the format for the month, and formatted it as "m". the cell now displays 1,2 and 3 (and with my formula month 3 is green). Is it possible to store these value but have january, february and mars displayed instead?

[JohnTopley]

If format as "mmm" or "mmmm" you will get "Jan" or "January" etc

[grenbeach]

Thanks alot!
So now ive got month and day to change color.

Im reading on google how to format cells to week, and how to calculate week from date using WEEKNUM. But im stuck..
Shout out if you have a solution for this aswell :D

[JohnTopley]

For MONTH

Select row 1

CF

=MONTH(C3)=MONTH(TODAY())


Select row 2

CF

=C2=WEEKNUM(TODAY())

[grenbeach]

Thanks! Now it works perfectly

[JohnTopley]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.