ExcelMercy
Board Regular
- Joined
- Aug 11, 2014
- Messages
- 151
Hey Everyone,
I'm looking for macro that will check two conditions if both check out then color the rows on one of the sheets.
In a nutshell:
Example:::
Market_Total
<tbody>
</tbody>
Market Confirm
<tbody>
</tbody>
(I can't seem to backcolor on the MrExcel.com forums, so I just changed the text color on here as an example. For the actual macro I would rather the back color change.)
Thanks to anyone who can assist!
I'm looking for macro that will check two conditions if both check out then color the rows on one of the sheets.
In a nutshell:
Rich (BB code):
If sheet:Market_Total's column B (Market ID) matches sheet:Market_Confirm's column A (Market ID)
True: If sheet:Market_Total's column E (Name id) is "A1111"
True: Color Market_Confirm corresponding row backcolor Blue
False: Do Nothing
False: Do Nothing
Example:::
Market_Total
Type | Market ID | Order by | System Code | Name id | First Name | Middle Initial | Last Name | Address 1 | Address 2 | City | State | Postal code |
1 | 213546 | * | AP_123_Lo_4 | A1234 | Billy | C | Smith | 111 N Street | Philadelphia | PA | 12345 | |
1 | 432452 | * | AP_123_Lo_5 | A1235 | Jacob | Johnson | 123 S Street | New Orleans | LA | 84001 | ||
1 | 3425267 | * | AP_123_Lo_6 | A1111 | Sue | Doe | 123 Main St | Atlanta | GA | 65431 | ||
1 | 8798567 | * | AP_123_Lo_7 | A1237 | Becky | A | Smith | 123 NorthWest Main Rd | Nashville | TN | 45678 | |
2 | 679732542 | * | AP_123_Lo_8 | A1238 | Stacy | Marshall | 9483 Walkway Dr | Houston | TX | 54634 | ||
2 | 3242368 | * | JF_123_Lo_1_SYS | A1111 | Larence | S | Donald | 2143 Systems Avn | New Orleans | LA | 84001 | |
1 | 6775674 | * | JF_123_Lo_2 | A1240 | Kimberly | Jones | 123 Timber Rd | Nashville | TN | 54001 | ||
1 | 53424567 | * | JF_123_Lo_2 | A1241 | Mike | G | Gareld | 136 South rd | Philadelphia | PA | 45201 | |
1 | 8798567 | * | HG_123_Lo_1_SYS | A1111 | Becky | A | Smith | 788 Landing Rd | Nashville | TN | 45678 | |
2 | 679732542 | * | HG_123_Lo_1_SYS | A1243 | Stacy | Marshall | 3 Moore Dr | Philadelphia | PA | 85201 | ||
2 | 3242368 | * | HG_123_Lo_1_SYS | A1244 | Larence | S | Donald | 212 Lake Drive | Philadelphia | PA | 95201 | |
1 | 6775674 | * | HG_123_Lo_2_SYS | A1111 | Kimberly | Jones | 1677 Trees Rd | New Orleans | LA | 84001 | ||
1 | 53424567 | * | HG_123_Lo_2_SYS | A1246 | Mike | G | Gareld | 13455 Northsouth Rd | Philadelphia | PA | 65201 |
<tbody>
</tbody>
Market Confirm
Market ID | System Code | First Name | Middle Initial | Last Name |
3242368 | JF_123_Lo_1_SYS | Larence | S | Donald |
8798567 | HG_123_Lo_1_SYS | Becky | A | Smith |
679732542 | HG_123_Lo_1_SYS | Stacy | Marshall | |
3242368 | HG_123_Lo_1_SYS | Larence | S | Donald |
6775674 | HG_123_Lo_2_SYS | Kimberly | Jones | |
53424567 | HG_123_Lo_2_SYS | Mike | G | Gareld |
<tbody>
</tbody>
(I can't seem to backcolor on the MrExcel.com forums, so I just changed the text color on here as an example. For the actual macro I would rather the back color change.)
Thanks to anyone who can assist!