Conditional Formatting

[Closed]
Report
-
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
-
Hello,

I am try to make daily usage spreed sheet.

I have formated cell to show only "ddd". I want weekends to be highlighted. How can I do this?

Regadrs

1 reply

Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
155
One way is to write below formula in Conditional Formatting Formula is :

=WEEKDAY(A1)=1

2nd way is to to write below formula in Conditional Formatting Formula is :

=TEXT(A1,"DDD")="SUN"

Try what ever you feel easy .....