Conditional Format

Conditional Format - Date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

R.C. - 13 Jul 2006 18:22 GMT

I have a question that I home y'all may be able to help me with: I am trying
to use Conditional Formating for some dates. What I want to do is have only
certain dates to be in bold and older ones not to be. ie., if I am entering
dates for June on a spreadsheet for the month of June, I just want the dates
for June of 2006 to be in bold and not the others. I have done value ranges
(equal to 6/1/06 to 6/30/06) but I don't want to always be doing this with
each month. Thanks!

Reply to this Message

Bob Phillips - 13 Jul 2006 18:50 GMT

Try a formula of say

=MONTH(A1)=MONTH(TODAY())

assuming the date is in A1.

If you span years, then use

=AND(YEAR(A1)=YEAR(TODAY()),MONTH(A1)=MONTH(TODAY()))

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> I have a question that I home y'all may be able to help me with: I am trying
> to use Conditional Formating for some dates. What I want to do is have only
[quoted text clipped - 3 lines]
> (equal to 6/1/06 to 6/30/06) but I don't want to always be doing this with
> each month. Thanks!

Reply to this Message