conditional Format Date?

  • Thread starter Thread starter Ken
  • Start date Start 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
 
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
 
Peo ... Ok I figured this out, but now need to ask more of
your expertise ... How to expand?

The 10-20-30 dates are not hard data ... They come from
another date field formatted mm/dd/yy. I did figure out
how to incorporate your formula ... but now same days for
all months are high-liting ...

I have Open/Target/Close dates (1,2,4, up to 12 a year of
each). Open/Close window dates are +/- 15% from target
date ... 1st order of business is to high-lite all Target
Dates ... then high-lite all Open/Close Target windows
(differenct color) for each respective target date over
the course of a 12 month period. Since the Open/Close
window for 1 date is approx +/- 55 days (365)*(15%) I have
set up 16 months of Calender ... Nov-Dec 02, 2003, Jan-Feb
04 ... (For 12 Target Dates window would be (30.5)*(15%)

Can I now adjust your formula to recognize "Year & Month"
as well as "Day" in effort to accomplish above? Any ideas
certainly helpful ... & Thank you for responding ... Kha
 
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
 
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
 
Back
Top