Conditional Formatting Issue

Hello, I am having problems with my conditional formatting. I have 3 columns with about 200 numbers. So for example here is my data:

C.....D....... E
100 103 108
101 102 105
106 107 104

Now I want to be able to enter numbers in column "A", which is like user input. The numbers that I will be entering will coincide with a number in one of the columns(so 101, 103, etc).

I set up 3 conditional formats. I want it to be if the data that is entered is column "C" to turn into a "Red" Color. If the number entered in Column "D" turn green. You get the jist. The problem is the numbers are not in sequential order. So when I enter say "104" it comes up as "red", which is the column "c" color because it is looking at numbers between 100-106, not the numbers themselves.

Is there a way to do this with a formula? The way I have been doing it is Cell Value Is Between C1-C3, etc etc.

I don't think I quite understand. Will the numbers in C:E be unique (i.e., a number in C will not show up in D or E and so forth)? If so, you can use =COUNTIF(C:C,A1) for the red conditional formatting. If not, please explain the logic of your sheet further, including what formatting takes precedence if the same number is in multiple columns.

I think perhaps Teylyn was a bit overzealous with the use of $. Using $A$1 locks the countif onto A1 when you drag it down. You'd want to use A1 or $A1 instead.