format date to separate different days of the week

[LIEKA]

I am very new to Excel and hope someone can help me. The date is in column B as Tuesday, 29 April 2014, but I need to format the spreadsheet in such a way that every day of the week is a different colour e.g. Tuesdays are Blue, Wednesdays will automatically turn pink etc. how will I do that?

[TMS]

You probably need to use Conditional Formatting to do that.

Regards, TMS

[AlKey]

Use formulas below for Conditional Formatting:

Assuming your dates are actually real dates and not text and your range in Column "B"

=TEXT(B2,"dddd")="Sunday"
=TEXT(B2,"dddd")="Monday"
=TEXT(B2,"dddd")="Tuesday"
etc,.

Apply formatting color as desired.