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?

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

"Hmtwngrl" wrote:

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?

Thank you - this will save at least an hours worth of work every month!!

"Toppers" wrote:

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

"Hmtwngrl" wrote:

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?

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.
--
Lon A.


"Hmtwngrl" wrote:

Thank you - this will save at least an hours worth of work every month!!

"Toppers" wrote:

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

"Hmtwngrl" wrote:

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?