How to Colour Column based on Cell value

[aneshdas]

friends,

Can anybody provide me a macro to colour columns in a worksheet based on a cell in that particular column?

ie,

I have a worksheet having datas and It is having columns from F to AJ. What I need is If any of the columns 7th row is " SUNDAY", I need that columns 8th raw to 500th raw should in Red colour. Ie if F7= SUNDAY, F8:F500 should be in Red colour.
Also If any of the columns 7th row is " SATURDAY", I need that columns 8th raw to 500th raw should in Yellow colour. Ie if F7= SATURDAY, F8:F500 should be in YELLOW colour.
Also, If any of the columns 7th row is " MONDAY", I need that columns 8th raw to 500th raw should in GREEN colour. Ie if F7= MONDAY, F8:F500 should be in GREEN colour.

Kindly help me with a macro for this

[aneshdas]

Or simply like,

If F7= TODAY() & SUNDAY, F8:F500 = RED
If F7=TODAY() & MONDAY, F8:F500 = GREEN
If F7=TODAY() & SATURDAY, F8:F500 = YELLOW

[Norie]

What about TUESDAY, WEDNESDAY, THURSDAY and FRIDAY?

[aneshdas]

Sir, It should be in normal colour.

[alvin-chung]

Hi aneshdas, will you consider using Conditional Formatting instead of macro?