Help! changing colour of cell if true

[eevoob]

Hi. Please help if possible.
I have a workbook with 2 sheets. A column of numbers in sheet 1 i
compared with a column of numbers in sheet 2. If they match, I wish t
highlight those that do in sheet 1. How do I achieve this.....hel
greatly appreciated

 

[Jason Morin]

Select the column (I'm assuming col. A) of Sheet1, go to
Format > Conditional Formatting, Formula Is, and use:

=$A1<>mycol

where "mycol" is the defined name (Ctrl+F3):

=INDIRECT("Sheet2!"&ADDRESS(ROW(),1))

HTH
Jason
Atlanta, GA

 

[sue]

Use conditional formatting. It's on the Format drop
down. Use the "If cell value is equal to, then click on
the little square at the end...go to the cell, click on
it, the click on the little box again to open up the
dialogue...then click on add, then do the same thing as
above, go to the next sheet and find the cell.

That should work.

 

[nsaa]

(Not a perfect solution)
* Assume that Column in Sheet 1 is in column A, and start in A1

1. Copy(or make a reference) the Column from Sheet 2 in a new Column i
Sheet 1 (Lets say Column B, starting in B1)

(Unhappily Excel doesn't support Conditional Formating over differen
Sheets or different books)

2. Select the Column A (Stay in cell A1 and press Ctrl+Shift+Arro
down)

3. Select Format -> Conditional Formating

4. Choose 'Formula is' and write
=A1=B1

5. Press Format... and Choose what ever format you want when the value
in col A equals col B (ex. Bold and Red)

6. Ok, Ok

Now each value that match should get the formatting you choosed in ste
5 (ex. Bold and Red)

In the Generic Calendar
'Calendar_2004-04-06.xls
(http://www.pvv.org/~nsaa/Calendar_2004-04-06.xls) this feature i
utilized to show moving holydays in Red in a Calendar.

Regards,
nsa

 

[eevoob]

Thanks for the replies. Thats done it............!!!!!!!!

 

[eevoob]

Didn`t really work. after all!!!.......I want to compare 1 value (Colum
A) in a range of values (Column B) and if it matches, highligh
it...continue with the next value in Column A and compare that wit
range of numbers in column B etc.....

TI