conditional Format Date?

K

Ken

I have formulas that create a Calender Month for each
month of the year ... I want to conditional format
multiple target dates within the month, but all months do
not have same target dates ... AND I want to do this using
only 1 condition line in conditional formatting (since I
am using the other 2 conditions) ...

Exampl ... I have the month of Jan 03 ... containing 31
days (created by formula) ... I want to high-lite the
10th, 20th, 30th using 1 conditional format.

Is there a way to write this? And my THANKS to the many
Excel Magicians that constantly respond to this board ...
Kha
 
P

Peo Sjoblom

Assume your dates start in A2, select the date range with A2 as the active
cell and use
formula is in the conditional formatting

=OR(DAY(A2)=10,DAY(A2)=20,DAY(A2)=30)

click format and select maybe a bold and blue coloured font..
Click OK twice
 
P

Peo Sjoblom

For this year the month of August

=AND(YEAR(A2)=2003,MONTH(A2)=8,OR(DAY(A2)=10,DAY(A2)=20,DAY(A2)=30))

Applied the same way
 
K

Ken

Peo ... (Hi)

I am really trapped with this one ... I can't seem to make
all the combinations work ... I have items I need to work
on 1, 2, 4 & 12 Times a year. I used your Calendar
formulas & setup 16 months of Calendar very nicely ... Nov-
Dec 02, Jan-Dec 03, Jan-Feb 04 ... Now I am trying to use
conditional formatting to target each date ...

IE:

If item has 12 checks & 1st date = 1/15 ... All months
would reflect a high-lited day approx 31 days from this
date.

If item has 4 checks & 1st date = 1/15 ... only those
dates approx 92 days from this date would be high-lited.

If item has 2 check & 1st date = 1/15 ... only those dates
approx 183 days from this date would be high-lited.

And yes ... if only 1 check ... that's the date. (Do note
that 1st date may occur anywhere in the year???)

I think this can be done, but my head is swimming ... :(

I might be able to write formulas in separate cells to
show all dates (maybe?) ... but am clueless as to how I
might be able to make the Calendar high-lite as indicated
above ...

Many thanks Peo (or to whoever, might take up this
challenge) ... I am going home ... Kha
 
Top