lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
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
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 |