Conditional Formating help.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

What function do I use in conditional formating?
I have part number on sheet1, I would like the cell the turn different color
if the part number on the cell equal any of the cells on column A. There are
hundred of rows. THANKS
 
Hi,

Select column a and then

Format|conditional format|formula is

paste this in

=COUNTIF($A$1:$A$10000,A1)>1

Pick a colour and click OK
 
Mike,

I forgot the mention that the problem is the data where the conditional
formating is on sheet1, but the reference data in column A is actually in
sheet2. They are not on the same sheet.
 
You can't refer directly from CF to cell references on another sheet, you
can get away with naming a range and using the name.
 
Back
Top