if both cells are same highlight

[veena]

hi there, i need a formula for conditional formatting to highlight the cell
if it is the same as the other cell. example below. I would like column B
cells to highlight if they are the same as A.
A B
120 100
150 120
100 100
Thank you for your help in advance.
v

 

[Mike H]

Hi,

Put this conditional format in b1 and pick a colour. Use the format painter
to copy it down column B

=AND(A1<>"",A1=B1)

Mike

 

[David Biddulph]

If your active cell is B2 when you are applying the CF,
Either Cell value is =A2
Or Formula is =B2=A2