Hi, I dont know if this is difficult or easy but I will try to ask it anyways.
I have a list in column A of items and the costs next to them and they change monthly. In column C I have a list of the ones which appear mostly often and a sumif with the costs next to it which show all of the costs of the specific items.
My question is, is there a formula or macro or something to highlight the cells In column A if they are costs associated with them in C.
So I know it is a little confusing but here it is visually.
<tbody>
</tbody>
So as you can see the Dog and Cat are included in the lis on the left so what the highlighting will do is because the dog and the cat on the right are shown added up it will highlight all of the dogs and cats on the left. There are no rats so those will not be highlighted neither the monkey or parrot etc...
Thanks a bunch!! Appreciate the help!!!
I have a list in column A of items and the costs next to them and they change monthly. In column C I have a list of the ones which appear mostly often and a sumif with the costs next to it which show all of the costs of the specific items.
My question is, is there a formula or macro or something to highlight the cells In column A if they are costs associated with them in C.
So I know it is a little confusing but here it is visually.
Item | Cost | Item | Cost | |
Dog | 20 | Dog | 85 | |
Cat | 10 | Cat | 15 | |
Rabbit | 5 | Rat | ||
Dog | 10 | |||
Cat | 5 | |||
Dog | 5 | |||
Rabbit | 300 | |||
Monkey | 400 | |||
Parrot | 400 | |||
Dog | 50 |
<tbody>
</tbody>
So as you can see the Dog and Cat are included in the lis on the left so what the highlighting will do is because the dog and the cat on the right are shown added up it will highlight all of the dogs and cats on the left. There are no rats so those will not be highlighted neither the monkey or parrot etc...
Thanks a bunch!! Appreciate the help!!!