skeller481
New Member
- Joined
- Jun 30, 2016
- Messages
- 10
Hi - I have a large spreadsheet with multiple tabs in it. I'm looking for a conditional formatting solution for the following - I'll explain:
Say in my worksheet I have Tab1 and Tab2. Tab1 has a list of customers we work with based on submissions they send in. on Tab2, I keep track of these customers and their submit vs purchased history. However, unless I add the customers manually onto Tab2 they will not be listed. What I would like is for the customers on Tab1 who are not listed in Tab2 to highlight in yellow, preferably using a condition or a formula and not macros.
EX:
<colgroup><col width="87" style="width:65pt"> <col width="64" style="width:48pt"> <col width="74" style="width:56pt"> <col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>DEF Co would be highlighted in Yellow because it does not show up on Tab2.
Say in my worksheet I have Tab1 and Tab2. Tab1 has a list of customers we work with based on submissions they send in. on Tab2, I keep track of these customers and their submit vs purchased history. However, unless I add the customers manually onto Tab2 they will not be listed. What I would like is for the customers on Tab1 who are not listed in Tab2 to highlight in yellow, preferably using a condition or a formula and not macros.
EX:
<tbody> </tbody> |
<colgroup><col width="87" style="width:65pt"> <col width="64" style="width:48pt"> <col width="74" style="width:56pt"> <col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>