Help with complicated macro

mewalker0

New Member
Joined
Jan 24, 2005
Messages
22
Looking to write a macro that will look at the cells above the active cell within a column which has dates in it and IF the date is less than the date in current cell it would look at the numbers in a different column and see if there is a duplicate number. If there is one it would high light the number cell. Any ideas? Or is there a better way to do this?
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
Possibly Conditional Formatting?

Can you post an example of what you're dealing with? (Look at the bottom of the page for the link to Colo's HTML Maker, which will let you do that).

Smitty
 

mewalker0

New Member
Joined
Jan 24, 2005
Messages
22
Book1
ABCDEFGHI
1
2TODAY1/29/2005
3
4NAMENUMBERDATE
5
6AAA3211/7/2005
7BBB1231/8/2005
8COCA2341/9/2005
9AAA4561/10/2005
10BBB1231/11/2005
11COCA3211/12/2005
12AAA5671/13/2005
13BBB3211/14/2005
14COCA3211/15/2005
15AAA3211/16/2005__----IF_C15_IS_EQUAL_TO_F2_IF_TRUE
16THAN_CHECK_AND_SEE_IF_B15_HAS_BEEN
17USED_BEFORE_AND_IF_SO_SHOW_"USED"_IN_D15
18
19
Sheet1
 

Forum statistics

Threads
1,147,846
Messages
5,743,520
Members
423,801
Latest member
paulj4177

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top