How to minus/add base on color cell in google sheet

 How to edit cells value base on color cell in google sheet

this is the result when we add save value in color cell 

copy this code on script as bellow 

function GetCellColorCode(input) 

{ 

var ss = SpreadsheetApp.getActiveSpreadsheet(); 

var cell = ss.getRange(input); 

var result = cell.getBackground(); 

return result 

}

open extension then go   app script and click on it 

then you can do as mention bellow image copy above code here and save 

this is code for get cell color name/code

here A mean your color cell value Colom , if that have on b Colum then you should type here B instant A, hope you may got it , if not comment us

=getcellcolorcode("a"&row())

this is if function

=if(D5="#ffffff",A5,if(D5="#ff0000",C5))

you can get more idea about using this video