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.
Best Answer
There are multiple worksheets in this document. One of the other worksheets had a group of cells highlighted/selected. Unselecting them allowed Conditional Formatting to be accessed.