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
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