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]

hai,
select the range and go to conditional format - new rule and use

=+WEEKDAY($A1,1)=1

Regards
witson

Witson,

Thanks for your response, but facing the same situation in your case, don't know why the formulae are not working...

 

[proficient]

Maybe there are no Sundays in the range or maybe your dates are text values that look like dates.

You can test if they dates are real Excel dates by using the formula =ISNUMBER(A1) which should return TRUE.

FormR,

I have tried your advice and getting TRUE in return... Could you please tell me what is wrong in my sheet?

 

[FormR]

I have tried your advice and getting TRUE in return... Could you please tell me what is wrong in my sheet?

I don't know - I have put an example on dropbox for you to take a look at.

https://www.dropbox.com/s/284kijkqf5oppo4/CF Example.xlsx

Does this help at all?

 

[proficient]

I don't know - I have put an example on dropbox for you to take a look at.

https://www.dropbox.com/s/284kijkqf5oppo4/CF%20Example.xlsx

Does this help at all?

Have seen but I don't want to highlight the whole row, just wanted to highlight the particular cell which is having the DATE (SUNDAY)

 

[FormR]

Have seen but I don't want to highlight the whole row, just wanted to highlight the particular cell which is having the DATE (SUNDAY)

Look again; that is what is happening (that row just happens to contain dates that are all sundays)

 

[proficient]

I don't know - I have put an example on dropbox for you to take a look at.

https://www.dropbox.com/s/284kijkqf5oppo4/CF%20Example.xlsx

Does this help at all?

Yes working fine but why not on my sheet...?

 

[proficient]

Look again; that is what is happening (that row just happens to contain dates that are all sundays)

Yes I have seen, You have used cell ref + 7 formula in it that is why all dates are sundays and highlighting the whole row...

 

[FormR]

Can you upload your workbook to file sharing site (like dropbox) and post the link here?

 

[proficient]

Give me any link where I can share my sheet for your ease, I don't have dropbox in my system...

 

[FormR]

Give me any link where I can share my sheet for your ease, I don't have dropbox in my system...

You can use dropbox from your browser:
https://www.dropbox.com/home

or google "free file sharing sites"