Skip to content

Instantly share code, notes, and snippets.

@gauravv7

gauravv7/scipt.js

Created March 22, 2019 08:24
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save gauravv7/d42b55caebfa40154dd646bc8b6c7b90 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save gauravv7/d42b55caebfa40154dd646bc8b6c7b90 to your computer and use it in GitHub Desktop.
Download ZIP
get google cell background color hex code
Raw
scipt.js
function getHex(input) {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var cell = ss.getRange(input);
var result = cell.getBackground();
return result
}
@gauravv7
Copy link
Copy Markdown
Author

gauravv7 commented Apr 10, 2019

find duplicates
=countif(A:A,A1)>1

https://stackoverflow.com/questions/21899516/how-to-highlight-cell-if-value-duplicate-in-same-column-for-google-spreadsheet

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment