Looking for help with an if then function

[Jede]

I am not sure if this would fall under VBA or cell formula. Basically what I am doing is making a number comparative, using a cell as a search box. What I am trying to do is turn the search cell (I7) red if there are no matches and green if it matches one of the numbers in column 1. Any help would be much appreciated. ( I have tried a few different codes and couldn't get it to work)

[crazyforexcel]

Hi maybe try conditional formatting these 2 rules for I7:


Red
=COUNTIF($A$2:$A$13,$I$7)=0

Green
=COUNTIF($A$2:$A$13,$I$7)>0

[Jede]

Hi maybe try conditional formatting these 2 rules for I7:


Red
=COUNTIF($A$2:$A$13,$I$7)=0

Green
=COUNTIF($A$2:$A$13,$I$7)>0

works perfect Thanks a bunch.

[crazyforexcel]

You're welcome!