Conditional Formating

[proficient]

Hi All,

I am here to ask you that let say if I have a table range A1:K10, all the cells housing dates, what I want to do is that if any cell have a SUNDAY the cell auto highlighted in red... please advise the formula...

 

[proficient]

I have highlighted the ranges with grey, here is the link below


https://www.dropbox.com/s/dt30n9wyuwclfyh/STITCHING%20PLAN%20FOR%20%20%2821-Oct-13%29.xlsx

 

[FormR]

It works fine for me using the steps you describe in post #9 with the formula =WEEDAY(L6)=1

See link:

https://www.dropbox.com/s/xehasnxxysbcih4/STITCHING PLAN FOR (21-Oct-13) with CF.xlsx

 

[proficient]

It works fine for me using the steps you describe in post #9 with the formula =WEEDAY(L6)=1

See link:

https://www.dropbox.com/s/xehasnxxysbcih4/STITCHING%20PLAN%20FOR%20%20%2821-Oct-13%29%20with%20CF.xlsx

Thanks FormR, it works fine now