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

"veena" wrote in message
...
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