highlight Fridays only

[lezawang]

Hi
I have dates in one column A and I want to heighligh Fridays days. So I highlighted the column A and went to conditional formatting --> Rule

=weekday(A1) = 5

and changed the color. But it is not working! any help please. Thank you very much

Tue, 01-Sep-20​

Wed, 02-Sep-20​

Thu, 03-Sep-20​

Fri, 04-Sep-20​

Sat, 05-Sep-20​

Sun, 06-Sep-20​

Mon, 07-Sep-20​

Tue, 08-Sep-20​

Wed, 09-Sep-20​

Thu, 10-Sep-20​

Fri, 11-Sep-20​

Sat, 12-Sep-20​

Sun, 13-Sep-20​

 

[Joe4]

You misspelled "weekday". It is "weekday", not "weekeday".

 

[Fluff]

You have misspelt the name of the function, also for Friday use =6 not 5

 

[lezawang]

Oh my god. Could not believe it. Thank you so much all.

 

[Fluff]

Glad we could help & thanks for the feedback.