Can anyone help me with a problem I'm having on excel 2010 please?
I am trying to change the colour of part of a row of cells when certain data is input. For example I want cells A13 to G13 to change to yellow when all cells in between are not blank and G13 is YES. If all cells in between were populated and G13 is NO I want the cells to turn orange.
Also I am trying to get cells A13 to H13 to turn green if H13 is populated by any name from the drop down list applied to that the H13 cell.
Any help is gratefully received.