Conditional Formatting
Closed
Ahmed713
-
May 23, 2009 at 03:37 PM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - May 25, 2009 at 02:37 AM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - May 25, 2009 at 02:37 AM
Related:
- Conditional Formatting
- Clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- Formatting usb mac - Guide
- Code for formatting android phone - Guide
- Conditional formatting based on date ✓ - Excel Forum
1 response
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
166
May 25, 2009 at 02:37 AM
May 25, 2009 at 02:37 AM
One way is to write below formula in Conditional Formatting Formula is :
=WEEKDAY(A1)=1
2nd way is to to write below formula in Conditional Formatting Formula is :
=TEXT(A1,"DDD")="SUN"
Try what ever you feel easy .....
=WEEKDAY(A1)=1
2nd way is to to write below formula in Conditional Formatting Formula is :
=TEXT(A1,"DDD")="SUN"
Try what ever you feel easy .....
