Ask Your Question

conditional formatting duplicacte values [closed]

asked 2014-02-20 23:40:16 +0100

tofucrisp gravatar image

how do I highlight duplicate values (here numbers) of one column A with two colors? One color for duplicate one for new addition? It should do that for the whole column A all numbers. Also how do I sort the bottom part of the spreadsheet by date of column E? When I try sorting it does nothing. I mark columns a-e and sort by column e (all dates, want it in ascending order). I have to compare two spreadsheets with numbers in colunm a which are daily updated. I usually copy paste the new spreadsheet info under the old one in one sheet and try to compare column a after sorting the new one by column e.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-19 11:40:32.407413

1 Answer

Sort by » oldest newest most voted

answered 2014-02-21 00:54:23 +0100

ROSt52 gravatar image

Without a look into your spreadsheet it is difficult to give you the right advice. You should have now enough karma to upload your file. Be careful about the content, this is a public forum.

Your statement "... sort the bottom part of the spreadsheet ..." makes me wandering why you only want to sort the bottom part. One typically sorts a table by columns from top to bottom. However, there could be reason for your bottom part sorting and for this more explanations or an upload is needed.

Marking A-E and sorting by E (dates) sounds correct. Are you sure that all entries in E are dates? Did you make a small test (maybe 5 rows) in a separate spreadsheet to see if and how things are working?

"...daily updates..." I might try to use Base if daily updates and comparisons are needed.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-02-20 23:40:16 +0100

Seen: 324 times

Last updated: Feb 21 '14