Conditional Formatting Applying Rule to Entire Column

[Vince Pacella]

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

 

[teylyn]

If you remove the $ signs in the formula, the references will be
relative to the cell

Applies: $A$2
Forumla: =EXACT(B2,C2)

if you use the format painter to copy this format down, it should
always compare column B and C of the current row.

in your second formula, there is a semicolon instead of a comma.

Foruma: =EXACT($B3:$C3)

this is hopefully a typo, otherwise the formula will always be FALSE

 

[Jacob Skaria]

--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 tab>Styles>Conditional Formatting>Manage rules>New rule>Use 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

 

[Ms-Exl-Learner]

Just follow the below steps.

Place the cursor in A2 cell and extend the selection by holding the shift
and down arrow upto A5000, keep in mind that the active cell should be A2
(Active cell will have a white background after selection also) now goto
format>>conditional formatting>>Condition 1>Formula is>>paste the below
formula
=EXACT($B2,$C2)
Click Format>>Font>Colour>Green and give ok.

Then Click Add>>Condition 2>> Formula is>>paste the below formula
=EXACT($B2,$C2)=FALSE
Click Format>>Font>Colour>Red and give ok and once again hit ok.

That's it! The conditional formatting is applied for A2 to A5000 cells.

Remember to Click Yes, if this post helps!