Guest User

Untitled

a guest
Dec 11th, 2017
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.53 KB | None | 0 0
  1. var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sheet1');
  2. lastrow = sheet.getLastRow()
  3. if (sheet.getRange(lastrow, 2, 1, 1) >0.00 && sheet.getRange(lastrow, 2, 1, 1) !='#N/A') {
  4. sheet.getRange(lastrow, 2, 1, 1).setFontColor('green');
  5. }
  6.  
  7. var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sheet1');
  8. var oValues = sheet.getRange(2, 2, sheet.getLastRow()-1, 1).getValues();
  9.  
  10. for (var i = 0; i < oValues.length; i++) {
  11. if (oValues[i] >0.00) {
  12. sheet.getRange(i, 2, 1, 1).setFontColor('green');
  13. }
  14. }
Add Comment
Please, Sign In to add comment