I need to get Excel to check dates for membership expiration and flag member if

[speedy18]

Well ive came up with another problem that i need solved again so i have
come back to the message boards.

If none of you guys remember me I am the secreatary of a Bass fishing
club in my area. My members are all supposed to be members of the
B.A.S.S.. What I would like excel to do for me is check their
expiration dates on their B.A.S.S. membership to see if they are still
good. If not then flag their name on my standings sheet so i can remind
them to renew their membership. All I have done is put the expiration
date of each member in another cell beside their name. What i would
like it to do is look at the date, if its = to or after todays date
then fill that cell with a certain fill color, which would alarm me
that the member is expired.

Any help would be greatly appreciated

Thank You
Speedy

 

[Don Guillett]

On the expiration date. Just use format>conditional format>cell value
is>greater than =today() and format as desired. Copy FORMAT down using the
format painter.

 

[speedy18]

Ok I tried that and it just left the cell's fill color as whit

 

[Debra Dalgleish]

To find the expired memberships, you should flag the dates that are less
than or equal to today's date:

Select the cells that contain dates (e.g. B2:B200)
Choose Format>Conditional Formatting
From the first dropdown, choose Formula Is
In the formula box, type a formula that refers to the active cell, e.g.:
=B2<=TODAY()
Click the format button, and choose a fill colour on the Patterns tab
Click OK, click OK

 

[Peo Sjoblom]

Fill colour? Do you mean it didn't change? The default is no colour at all,
if that's the case
you might have text dates (text will always be larger than numbers), check
as follows
Assume the dates start in A2 going down, in a help column use

=ISTEXT(A2)

copy down, if you'll get TRUE they are text. If so post how the dates look

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[speedy18]

Ok I tried that, the result from that test was false. I have formatte
the column as dates. I also formatted the date to where it just show
month and year, for this is how our B.A.S.S. memberships expire. Sinc
the original post I tried going <= to today() and it filled the cel
yellow like i formatted it to do under conditional formatting, but the
no matter what date i put in it stayed yellow like it was always les
than or equal to todays date. If me attatching a copy of the standing
sheet to this message will help so that all can look at it I will, jus
let me know.

And I hope I am posting these messages in the proper place, I have onl
been a member of this board for a couple of months and dont have to us
it very often, but I am sorry to say I do not understand what you mea
by keeping discussion in the newsgroup.

Thank you for your help
Speed

 

[Debra Dalgleish]

In the Conditional Formatting dialog box, did you choose 'Formula Is'
from the first dropdown box?

 

[Don Guillett]

Debra,
What is wrong with cell value is | less than |=today(). I just tested and it
was fine.

instead of formula is.

--
Don Guillett
SalesAid Software
(e-mail address removed)

To find the expired memberships, you should flag the dates that are less
than or equal to today's date:

Select the cells that contain dates (e.g. B2:B200)
Choose Format>Conditional Formatting
From the first dropdown, choose Formula Is
In the formula box, type a formula that refers to the active cell, e.g.:
=B2<=TODAY()
Click the format button, and choose a fill colour on the Patterns tab
Click OK, click OK

 

[Debra Dalgleish]

Yes, that works fine. However, your original instructions said 'greater
than', which matched the poster's request.

I offered an alternative solution, which would highlight dates on or
before today's date, using Formula Is.

My subsequent question was an attempt to clarify which method the OP was
using.