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
- Excel formula to change cell color without conditional formatting - Excel Forum
- Excel conditional formatting if another cell contains specific text - Excel Forum
- How to clear formatting in excel - Guide
- To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
- Phone formatting software for pc - Download - File management
1 response
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
165
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 .....