I have an excel spreadsheet that we use as an ongoing log of data,
within this data there is one specfic column that I want to check
against a list of data and I am wondering if this is possible?

Specifically, when the cell in this column is entered, can excel
check
that number against a set list of numbers within another row and turn
the background color of that cell a different color if the number
entered is found in the existing list of numbers in another row in
the
spreadsheet?


If this is possible, can it be checked against 2 lists of numbers,
returning a different color cell background depending on what list
(if
either) the number is found in?


Any help would be greatly appreciated,
Tony

Use conditional formatting with a formula something like this:

=NOT(ISERROR(MATCH(E20,$C$20:$C$25,0)))

Where in this case $C$20:$C$25 is the list of existing numbers and E20 is
the cell being formatted.

You can add up to 3 format conditions, each pointing to a different list and
having a different color.

Tim



"TonyR" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have an excel spreadsheet that we use as an ongoing log of data,
> within this data there is one specfic column that I want to check
> against a list of data and I am wondering if this is possible?
>
> Specifically, when the cell in this column is entered, can excel
> check
> that number against a set list of numbers within another row and turn
> the background color of that cell a different color if the number
> entered is found in the existing list of numbers in another row in
> the
> spreadsheet?
>
>
> If this is possible, can it be checked against 2 lists of numbers,
> returning a different color cell background depending on what list
> (if
> either) the number is found in?
>
>
> Any help would be greatly appreciated,
> Tony
>