if both cells are same highlight

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
 
M

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
 
D

David Biddulph

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use a variable in a ShapeRange.Increment 0
Weigh tasks 0
Average problem 1
Conditional Formatting 4
Comparing two lists in Excel 1
Function 2
Highlight Text 1
Converting URLs in comments to Markdown-formatted links 2

Top