Conditional Format Date/Day (ddd)?

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

What I have ...

Cell A1 contains a date (mm/dd/yy)

Range B1:B7 contains a formula producing weekdays
formatted (ddd) ... Mon, Tues, Weds, etc w/e Sun.

I am trying to conditionally format cells in Range B1:B7
to high-lite based on day found in cell A1.

Example: If Cell A1 contains 01/15/03 ... Weds should
high-lite ...

I would have no trouble with hard data, but assume issue
is due to formula or format I have in Range B1:B7 ...
or ... yes, I admit it ... my lack of intimacy with
Excel ... Thanks ... Kha
 
Select B1:B7 with B1 as the active cell, do
format>conditional formatting
formula is and in the formula box put

=WEEKDAY($A$1)=WEEKDAY(B1)

click the format button and select fonts and format (red
font maybe), click OK twice Works for me

Regards,

Peo Sjoblom
 
Back
Top