Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Compare cells
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? |
#2
|
|||
|
|||
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 -----Original Message----- 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? . |
#3
|
|||
|
|||
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 "johnny" wrote: 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? |
#4
|
|||
|
|||
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 "johnny" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I compare data in two worksheets to find matching cells? | Excel Discussion (Misc queries) | |||
How do you compare text in cells | Excel Worksheet Functions | |||
How do I compare cells in a column | New Users to Excel | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) |