Conditional formating for date range
Closed
abdul bari
-
May 7, 2010 at 02:45 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 7, 2010 at 05:49 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 7, 2010 at 05:49 AM
Related:
- Conditional formating for date range
- Excel date format dd.mm.yyyy - Guide
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Conditional formatting if another cell contains any text ✓ - Excel Forum
- Selection.autofill destination:=range ✓ - Excel Forum
- Excel if range of cells contains specific text ✓ - Excel Forum
1 reply
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
May 7, 2010 at 05:49 AM
May 7, 2010 at 05:49 AM
Let say this date in in column A
then select column A
go to conditional formatting and enter this formula
=WEEKDAY(A1)=6
and click on the format button of the conditional format and choose color of your choice
then select column A
go to conditional formatting and enter this formula
=WEEKDAY(A1)=6
and click on the format button of the conditional format and choose color of your choice