Compare cells

J

johnny

Using Excell 2003.
I have 7 cells in a row each with a different number in each cell.
Selecting the first cell I wish to compare the number against a column
consisting of 21 numbers.
If the number in the selected cell is the same as a number in the column I
want to select that cell background colour yellow.
If the number in the selected cell does not correspond with a number in the
column then move to the next cell on the row and repeat until all 7 cells on
the row have been checked.
Have tried various ways but am stuck.
Can anyone help?
 
J

Jason Morin

Select the seven cells, go to Format > Conditional
Formatting, select "Formula Is" and put:

=COUNTIF($I$1:$I$21,INDIRECT("rc",0))

Press the Format radio button and format as desired.

To copy the CF to additional rows, select the seven
cells, click on the paintbrush icon, and select the rows.

Change the range if necessary.

HTH
Jason
Atlanta, GA
 
D

Duke Carey

Use Conditional formatting, using this formula -

=MATCH(a1,Validate,0)>0

which assumes cell A1 is active when you call up the conditional formatting
menu, and also assumes that you name the range of 21 numbers 'Validate'

Duke
 
T

Trevor Shuttleworth

Johnny

look at Conditional Formatting.

Assuming the cells you want to check are in row 1 and the cells you want to
check them against are in rows 2 to 22 below, first select cells A1 to G1,
that is, all 7 cells.

Then, from the menu, select Format | Conditional Formatting...

Set the Condition to Formula is: =COUNTIF(A$2:A$22,A$1) and choose
some appropriate formatting, for example, yellow background (patterns |
colour = yellow)

If it is the same column of numbers for all the cells, then change A$2:A$22
to $A$2:$A$22 ... adjust the column and rows to meet your needs.

Regards

Trevor
 
Top