So I have a sheet open in Excel 2013. I have come to add some conditional formatting and cannot do so due to it being greyed out.
My suspicion is that it is due to this [Group] thing. I know that shared sheets lose conditional formatting but I can't work out what the [Group] thing means or how to get rid of it.
It is normally stored on a network share but even dragging and opening locally doesn't resolve this. The sheet is not protected nor shared in Excel.