Excel 2007 : Highligting todays date in a list over max number of days in a month. Halp?

[voxlund]

I have put the numbers 1-31 in A3:A33 to indicate the date of any month.
I want the number corresponding to todays date to be highlighted with background color.
:04.02.2012 example:
1
2
3
4 <---- Background color goes here since it's the 4th of this month.
5
6
....

Is it possible to also put background color in B6,C6,D6,E6 and F6 when "date 4"(A6) is colored?

Thanks for looking in to it. :)

[Fotis1991]

Hi and welcome to the forum.

Highlight the range that you want and then>>Format>>Conditional Formatting>>Rules>>put this formula.

(DAY(TODAY())=$A3)

Hope to helps you.

[voxlund]

It worked exactly how I wanted to! :D Fantastic! Thanx to my explanation skills and your imba knowledge. :P Thank you very much!
Now how do i mark this thread as [Solved]?

Thank you again!

[Fotis1991]

You are welcome!

Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes.