SparkMonkeyHellion
Banned
- Messages
- 546
- Location
- Guantanomo Bay, Cuba
I think what I'm trying to do is a macro, and anyways, I know you can do it all the way back to Excel 95.
Here's what it is, it's so simple:
1) I have 3 spreadsheets
-a) Master list of all accounts
-b) terminated accounts
-c) active accounts
I need to make a) search both b) and c) and color a row according to where it finds the name.
There are a couple other provisos/problems but I can get that sorted out by hand, or work on it later, the vast majority of the data is just going to be "Is it here? No. Okay, is it there? Yes, okay, color it blue"
I tried to google some walkthroughs, but like I said, I'm not even sure if "macro" is the right feature that I'm looking for.
Here's what it is, it's so simple:
1) I have 3 spreadsheets
-a) Master list of all accounts
-b) terminated accounts
-c) active accounts
I need to make a) search both b) and c) and color a row according to where it finds the name.
There are a couple other provisos/problems but I can get that sorted out by hand, or work on it later, the vast majority of the data is just going to be "Is it here? No. Okay, is it there? Yes, okay, color it blue"
I tried to google some walkthroughs, but like I said, I'm not even sure if "macro" is the right feature that I'm looking for.