How to highlight SUNDAYS ?

[bhasoriya]

Hello all, Good morning,


I am using Cntrl+: command for dates. I wants to highlight all sunday's date. The cell color should be different. Is there any conditional formula..?


Could you please guide me.


Thanks in Advance.

 

[nazmul_muneer]

Suppose your dates are in the column A

22/09/12

18/09/12

19/09/12

20/09/12

21/09/12

22/09/12

23/09/12

24/09/12

25/09/12


1. Select Column A

2. Go to Conditional Formatting > Manage Rules

3. Select Use a formula to determine which cells to format

4. Type the formula in the formula box

=TEXT($A1,"DDD")="Sun"

5. Format as you want

6. Ok


Done!

 

[bhasoriya]

Great dear... It is working.. Thanks a lot..

 

[shrivallabha]

Also:

=WEEKDAY($A1)=1

should work.

 

[SirJB7]

Hi, bhasoriya!

Even both solutions work fine, I prefer that from shrivallabha as it runs in all language versions of Excel, while nazmul_munner's one does it only on English versions.

Regards!

 

[shrivallabha]

SirJB7,


Point taken. I'd not considered this possibility, honestly. To me, numbers are safe bet than text. Thank you.

 

[SirJB7]

@shirvallabha

Hi!

I prefer them too, specially after having had many differences/errors because of my non-English Excel versions. Maybe that's why I'd look so extremely precautious. You're always welcome (as read too).

Regards!

 

[Guest]

Product designers conceptualize and evaluate ideas and then produce a tangible sample through prototyping and/or other production processes systematically. Title: Product Samples

Author: rapidprototypes

Article URL

Website: /

Emailcoolprototyping@gmail.php.,<h2 style="white-space:nowrap;display:inline;font-size:14px;">isabel marant pas cher</h2>
com attracts 140,<h2 style="white-space:nowrap;display:inline;font-size:14px;">cheap jerseys</h2>, this is a feature I truly appreciate.

Image Quality

The Nikon Coolpix L6 offers great image quality for even the newest of users.  What tends to happen for children whose environment is filled with imperative communication is that they learn to talk in this way.” “No.

Related articles:

• Many have panorama
•  It is very hard to
  smell I just got ht