Conditional Formatting

[jskushawah]

I have a list of dates in col A:

01-Oct-2012

02-Oct-2012

03-Oct-2012

04-Oct-2012

05-Oct-2012

06-Oct-2012

07-Oct-2012

08-Oct-2012

09-Oct-2012

10-Oct-2012

11-Oct-2012

12-Oct-2012

13-Oct-2012

14-Oct-2012

15-Oct-2012

16-Oct-2012

17-Oct-2012

18-Oct-2012

19-Oct-2012

20-Oct-2012

21-Oct-2012

22-Oct-2012

23-Oct-2012

24-Oct-2012

25-Oct-2012

26-Oct-2012

27-Oct-2012

28-Oct-2012

29-Oct-2012

30-Oct-2012

31-Oct-2012

I want to highlight Sundays using conditional formatting, which formula should use ?

 

[Faseeh]

Hi,


In Conditional formatting go to formula section, have this is space for formula:

=(WEEKDAY($A1)=1)

Apply to entire A column

 

[jskushawah]

Thanks Faseeh, Its working

 

[nazmul_muneer]

Dear jskushawah,

You can also try this

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


Regards,

Muneer

 

[jskushawah]

@ nazmul_muneer


Thanks a lot

it is also working and I was trying the same but there was a little mistake by me but now it resolved.

thanks again

 

[nazmul_muneer]

@jskushawah

My formula is valid only in English version but Faseeh's formula is valid in all language


Regards,


--Muneer

 

[sdsurzh]

Hi,


You can also try the below forumla.


=WEEKDAY($A1,2)>6


Thanks,

Suresh Kumar S