Excel question


#1

how do you make it so it highlights any duplicate entries in red?

feel free to tell me how or to make shite jokes, either are fine


#2

Conditional formatting and duplicate values


#3

Select the cells then select conditional formatting in the home tab, then highlight cells rules and duplicate values.


#4

ok great

but just for fun, imagine if someone didn’t know the difference between excel and google spreadsheets, what would they do then?


#5

:rofl:


#6

Copy and paste it into excel


#7

#8

ah fuck it, i give up


#9

I had to do this and couldn’t find a way. Ended up making a formula saying if cell is a duplicate return true, else return false, then ran a conditional format on true


#10

yeah i cba

i’m not paid to do spreadsheet bollocks, fuck em


#11

Does it need to be self maintaining or a one off, if the later just add a column, do a countif by each value to see how many cells in the column match that value then filter on that column for values over 1 and manually apply the highlight


#12

wat


#13

If you had a list of values in column A in column B in the first row you want to check, say cell B2 put the formula =countif(a:a,a2) and it will count all the values in column a that match a2. Copy this down for all the values, then add a filter to column b and deselect 1 giving you all the duplicates


#14

so you have to do a different value for each cell in a list?


#15

The formula will be relative (unless you fix it with $ before the column and/or row) so when you copy the formula down it will automatically know to refer the the cell on the left