fortune-sheet
fortune-sheet copied to clipboard
Change the color of the cell based if condition
conditional cell color change.
if(current_cel > other_cel: green, red)
Is there any example in excel or google sheet
@shuanhukexuejia not sure, let me check
@shuanhukexuejia Conditional Formatting in excel. https://www.ablebits.com/office-addins-blog/change-background-color-excel-based-on-cell-value/
@gudipudipradeep There is some different from the feature you discribe, conditional formatting is cellValue > specificValue
while what you desire is currentCellValue > otherCellValue
@shuanhukexuejia that's correct, Just to know how we can achieve this kind of behavior here.
@shuanhukexuejia that's correct, Just to know how we can achieve this kind of behavior here.
Maybe it should base on conditional formatting(still incomplete), then we can modify it to make it compatible with custom formatting rules based on cellValue.Thus the first step should be completing conditinal formatting