1

I need to setup conditional formatting to highlight any cells in the range that are not equal to the first cell. I have attached 2 pictures the first is how the data is typically entered and I have highlighted the range that I would like the formatting to apply too. The second picture is how I would like conditional formatting to highlight(ignoring blanks). I have tried multiple things but nothing seems to work quite as I would like.

Image1:
enter image description here

Image2:
enter image description here

Improve this question
1
  • It would be useful if you include the range your data is in, so people answering can give exact samples based on your data
    – Yisroel Tech
    Commented Jan 15 at 14:34

1 Answer 1

Reset to default
0

For example, if you have those numbers in Column B, with the first number in B2 (after the column header in B1), you can use a rule with a formula like this:

=AND(B3<>$B$2,B3<>"")

enter image description here

And set the Applies to to:

=$B$3:$B$1000

enter image description here

Improve this answer
2
  • This works perfectly, thank you!
    – Joseph Bowditch
    Commented Jan 15 at 15:14
  • If my answer answered your question, please accept it as the Accepted Answer by ticking the checkmark to the left of the answer
    – Yisroel Tech
    Commented Jan 15 at 15:18

You must log in to answer this question.

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