color matched values excel formula https://www.lotterypost.com/thread/200487 Lottery Post Forum Topic: color matched values excel formula en-us Lottery Post RSS Generator Reply #2 https://www.lotterypost.com/thread/200487/1405149 https://www.lotterypost.com/thread/200487/1405149 Tue, 15 Sep 2009 00:01:55 GMT grass34 i have done my research while wait replys from LP members. thanks everyone who looked :)

solution:

=ISNUMBER(MATCH(TEXT(H3, 00 ),A4:F4,0

]]> grass34 Reply #1 https://www.lotterypost.com/thread/200487/1405132 https://www.lotterypost.com/thread/200487/1405132 Mon, 14 Sep 2009 23:52:10 GMT hotshot4 I think you would need a marco to change the colors in a cell, may be able to come up with a formula in

column I that would show you have a match in column H. But need more information about what your

trying to do.

]]> hotshot4 color matched values excel formula https://www.lotterypost.com/thread/200487 https://www.lotterypost.com/thread/200487 Mon, 14 Sep 2009 17:32:42 GMT grass34 This may be out of the realm, but is there a way I can have a cell(s) with text in it change to another color?

To be a little clearer. Cell H3 (but i have a small formula in cell h3) has 9 and cell A4 has the same value (9) (or number or value etc..)

i would to color red for H3 if it find matches in range A4:F4

I am probably streching the bounds of this program, but any feedback would be appreciated.

]]> grass34