if both cells are same highlight
 

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

if both cells are same highlight
 

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

"veena" wrote:

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

if both cells are same highlight
 

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