I have Excel 2008 for mac. I have used conditional formatting to change the colour of a row when a specified field has a given name.
The problem that I have is that I need to apply 7 different colours for different values, but you can only apply three different conditional formatting options to each cell.
Does anyone know of a way to solve my problem?
Thanks
Richard
The problem that I have is that I need to apply 7 different colours for different values, but you can only apply three different conditional formatting options to each cell.
Does anyone know of a way to solve my problem?
Thanks
Richard