Conditional Formatting help

[Geofg_88]

Hi Everyone

I need to set up conditional formatting to change the colour of a cell if it is equal to the value of another cell on the same row

E.g I need C3 to go green if it contains the same value as B3 and red if not

I have tried many different formulas but all do not have the desired effect

Any help on this would be greatly appreciated

Cheers

[ChemistB]

Is this specifically related to columns C and B or are there multiple columns and if any two in the row are the same, you want the formatting?

That's an interesting version of Excel you have.

[Geofg_88]

Basically I have a spreadsheet with four columns to test some simple (supposed to be) formula/conditional formatting

Column A contains Numbers, Column D is the destination for the formula of B plus C

E.g.

A B C D => A=D so D should turn green
4 3 1 4

I am trying to apply conditional formatting to all rows so that if D2 is the same as A2, D2 goes green. The conditional formatting needs to apply only to the row D is in. So D2 doesn't see that A5 is the same value and goes green.

Cheers

[ChemistB]

Select column D, go to Conditional Formatting > Formula

=AND(ISNUMBER($A1),$D1=$A1) and format as green.

Add a second format for Red with

=AND(ISNUMBER($A1),$D1<>$A1)
Does that work for you?

[Geofg_88]

No It doesn't look like it has worked

I have quite a few columns with A and D containing equaling values but the colour formatting isn't correct and they are showing up as red.

I tried changing the value of A on one of the rows that had the formatting correct to see what happened and a cell three rows up changed its formatting

Cheers

[ChemistB]

Okay, go back into the conditional formatting and make sure the formula is still correct. If your active cell wasn't D1, it will probably be wrong. Another possibility is that, although A and D may look like they are identical, if you extend the # of digits visible, you'll see that there are differences (Excel calculates out to 15 digits). If you could attach a dummy workbook where you applied the Conditional formatting, it would be easier to troubleshoot (Go Advanced > Manage Attachments)