highlight an entire row if a date in one column falls between a given range

C

cfmartin76

Apparently Iposted this on the wrong newsgroup, so I'm reposting here.

I would like to know if there is a macro that automaticalle highlights
an entire row if a date located in one column falls between a given
range:

TITLE DAY1 DATE
1 Math Mon 5/15/06
2 History Tue 6/17/06
3 English Wed 8/13/06


If I have the above information, can I create a macro to highlight in
bold the entire row if a cell in column "DATE' is between 6/01/06 and
6/20/06? (row 2 in this case)


Thanks!
 
R

Ron Coderre

Try something like this:

Select Row_2 through Row_4 (entire rows)

From the Excel main menu:
<format><conditional formatting>
Cell formula is: =AND($C2>=(--"6/1/2006"),$C2<=(--"6/20/2006"))
Click the [Format...] button
Set your formatting scheme
Click [OK]
Click [OK]

Adjust range references to suit your situation.

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top