if both cells are same highlight

  • Thread starter Thread starter veena
  • Start date Start date
V

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
 
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
 
If your active cell is B2 when you are applying the CF,
Either Cell value is =A2
Or Formula is =B2=A2
 
Back
Top