--Select the range of cells. Assume this range is A3:A10. Please note that
the row reference 3 mentioned in the formula is the active cell/row in the
selection. Active cell will have a white background even after selection

--Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a
formula to determine which cells to format

--Enter this formula in the box below:
=AND(B3<"",EXACT(B3,C3))

--Click the Format button. Select the desired style(s). Click OK


--
Jacob


"Vince Pacella" wrote:

I have three columns that I'm concerned with A, B, C

Column A is what I want to format with coloriing. It's Value is irrelevent.

For A2
The Condition is "Green" colors if formula =EXACT(B2,C2)
The Condition is "RED"colors if formula =EXACT(B2,C2) == FALSE

That works fine.

In Manage Rules it says
Applies: $A$2
Forumla: =EXACT(B2,C2)

It's when I copy/paste the format down column A for teh thousands of rows
that I get a single rule made:

Applies to: $A$3:$A$5000
Foruma: =EXACT($B3:$C3)

I tried playing with the dollar signs, but I can never get the Formula to
have the right row reference for a given row in the range