so I have this sheet that I'm working on in which it will highlight which numbers you've matched. My main problem that I am having is that I also want it to tell you how much you've won. Anybody care to look at it and see where the problem may be coming from.

also, I should make it clear that I am referring to my "Winnings" column

Hi,

See attached.
Because the numbers showing how many matches (G5:H14) are generated by formulas, wrapping those references in VALUE() fixes the problem.

However, I've also included another worksheet that shows how I would do it personally. It involves one helper column that can be hidden and a MUCH shorter formula.

Hope that helps.

S :)

Thanks for explaining that VALUE function, you made it do exactly what I wanted :D

Also, I looked at your formula, that is much easier, I also learned what vlookup does, that is one very helpful function

Thanks a lot for your help. :)

Pleasure is all mine. Glad to help :)

sldfghtrike wrote:
sldfghtrike;1604009 Wrote:
so I have this sheet that I'm working on in which it will highlight
which numbers you've matched. My main problem that I am having is that I
also want it to tell you how much you've won. Anybody care to look at it
and see where the problem may be coming from.

also, I should make it clear that I am referring to my "Winnings" column


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+




This works for me as a conditional format,
=NOT(ISERROR(HLOOKUP(D6,B3:G3,1,FALSE)))

Insert appropriate cell locations and then pick your font color when the
condition is true.

HTH