Conditional Formatting

[Guest]

In a workbook... I have two sheets (Sheet 1 and Sheet 2), In sheet 1, I would
like to conditional format color in a cell (A2) if the number in that cell
(UGMU8093083) is represented anywhere in column B of sheet 2.
TFTH,
Tom

 

[Guest]

Hi,

you can name the cell A2 in sheet 1 to for example ABCD and then active the
column B in sheet 2 and then Format>Conditional Formatting and then put "Cell
value is" in the first combobox from the left and put "Equal to" in the
second combobox and put =ABCD inthe next textboxand then determind the color
you want and then click ok

hope it will work

Thanks