Checking entries against a column of data

  • Thread starter Thread starter TonyR
  • Start date Start date
T

TonyR

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
 
y sure:
Start name-define ur refencelist as fx. List1 and List2
then select ur other list and insert this formula in cond.format
=COUNTIF(List1;A1) ' change A1 to ur first cell in the range
select color
select add
do the same just antoher color and user List2 here


"TonyR" skrev:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Checking entered data against exisitng data 1
How to filter rows data based on background color of individual cells 1
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Excel Numbering rows by font color, but skipping blanks 1
Count yes against name 1
macro or formula to find an account number in another list of numb 1
Excel VBA - counting cells by colors and names to it in two different rows. 0
Check for duplicate entries in pull-down list 1

Back
Top