Hi there,
I have a spreadsheet that has values in the end column that read Addition, Deletion or No Change. I am trying to get the row cells in Column A to shade red, green or yellow depending on the value of the cells in Column I. I have tried the folllowing:
="IF(I4=No Change)"
I chose the fill to be green for this but when I click OK nothing happens but I do not get any error messages.
Any ideas?
Many thanks in advance
Steve
I have a spreadsheet that has values in the end column that read Addition, Deletion or No Change. I am trying to get the row cells in Column A to shade red, green or yellow depending on the value of the cells in Column I. I have tried the folllowing:
="IF(I4=No Change)"
I chose the fill to be green for this but when I click OK nothing happens but I do not get any error messages.
Any ideas?
Many thanks in advance
Steve