Conditional formatting from other worksheet

H

Hmtwngrl

I have 2 worksheets.

I want column E in Sheet 2 to look at the data from Column A in Sheet 1 and
if there are matching numbers then color the cell.

Conditional formatting is not working and neither are any of the formulas I
have tried. Any suggestions?
 
T

Toppers

Make Column A on Sheet1 a named range e.g ColA (Insert=>Name=>Define==>...)

On sheet2 highlight Colum E:

Condition Formatting

FormulaIs: =COUNTIF(ColA,E1)>0

Select colour

HTH
 
L

LonA

Hey hometown, you could also group the two sheets together if you are wanting
to do an absolute reference. You do that by clicking on the first sheet, hold
down 'ctrl' and then click on the second one.
 
Top