I am trying to format in Google Spreadsheets and am unsure how to do the following:
- If column G is equal to “Yes” then it will format the entire row by changing to font to grey, italic and strike through the row.
I can set the format to change column G to grey font and grey background but cannot work out how to set the whole row to change the format. And is it possible to make the strike through?
Any help is appreciated!