-3

I have used conditional formatting to change a row's color for specific values of another cell before but now I want it to change color when the value of a cell is equal to the one next which all have different values.

Is there a formatting method for this too? I have tried =$AL5" for example, but it always highlights the cell regardless of the value in the mentioned cell. I would like to do this for a row of cells with each of them highlighting when they are equal to the cell next to them.

Improve this question
4
  • 1
    Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking.
    – Community Bot
    Commented Jul 24, 2022 at 7:38
  • 3
    Cna you please let us know what you tried? A quick search shows a lot of examples of using conditional formatting with formulas
    – cybernetic.nomad
    Commented Jul 24, 2022 at 17:18
  • Could you provide a sample here?
    – Lee
    Commented Jul 25, 2022 at 9:09
  • I provided an image, I think it explains what I mean.
    – Soner Deniz Ersoy
    Commented Nov 5, 2022 at 20:57

1 Answer 1

Reset to default
0

Assuming you are comparing columns A and B, use the formula below for your conditional formatting rule:

=$A1=$B1

Result

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .