I am trying to apply conditional formatting to the cells in this example spreadsheet.
Currently, I have a list of clients that occasionally report issues in the corresponding month columns. Once the issue is reported, the cell changes color to red based on the conditional formatting rule: if cell is not empty -- background color -> red.
Once the issue has been addressed / fixed, strikethrough is applied to the cell by the user. I would like to be able to change the background color of the cell at this point to green to show visually that the issue is resolved and visually separate resolved issue cells from unresolved issue cells. In a perfect world the solution would be along the lines of: Format cells if -- cell contains 'strikethrough' -- apply background color -> green.
Any help would be greatly appreciated!