Conditional Format: Dates

J

JEM

Date is displayed in cell like this:

Thursday, January 01, 2004


Currently, cells have no cell color format.
How can I set formatting so cells containing 'Sunday' are a different color?
Is there a formula I can use or some function that will do this for me?
 
P

Peo Sjoblom

If the dates are text use

=ISNUMBER(SEARCH("Sunday",A1))

in the formula is box, if they are real dates use

=WEEKDAY(A1,2)=7

format>conditional formatting and formula is
 
J

JEM

Thanks, it worked!

Peo Sjoblom said:
If the dates are text use

=ISNUMBER(SEARCH("Sunday",A1))

in the formula is box, if they are real dates use

=WEEKDAY(A1,2)=7

format>conditional formatting and formula is

--

Regards,

Peo Sjoblom
Click to expand...
 
Top