CODEWITHSUNDEEP
excelexcel-formulaconditional-formattingcountifexcel-2016
Lars Hovden
Lars Hovden

Reputation: 333

Highlight unique value in row

I have data that I would like to highlight if it is unique in the row.

The data is an export from a SQL Table and I want to check that the data is setup correctly.

For example:

Product     Plvl1       Plvl2       Plvl3       Plvl4
Product1     3.9         3.9        **4.1**   3.9
Product2     1.135       1.135       1.135     1.135
Product3    4            **5**       4        4

Upvotes: 3

Views: 1423

Answers (3)

yass
yass

Reputation: 869

Select each Row alone or change apply to for each Row

You can use Highlight Cells, Duplicate Values and instead of Duplicate use the arrow and choose Unique and choose the Format you want

enter image description here

Upvotes: 3

Gowtham Shiva
Gowtham Shiva

Reputation: 3875

Agree with Jeeped's answer. There is one more way that you could do this,

  • Select the range of cells that you want
  • click conditional formatting --> highlight cell rules --> duplicate values
  • select unique in the dropdown, select a color of your choice and press OK

Upvotes: 2

user4039065
user4039065

Reputation:

Create a conditional formatting rule based upon the following formula,

=countif($b:$e, b2)=1

enter image description here

Upvotes: 6

Related Questions