Conditional formatting in alerts
How can I get conditional formatting to display consistently in messages sent through alerts? I have one sheet where this works well, and colour-coded rows appear as just as they do in the sheet itself. However, I have another sheet where only some of the formatting is shown, and none of the colour coding (which is based on the presence of a single character (A, O or null) in the first column of the sheet. In this latter example, one column appears coloured, which appears to bear no relation to any of the conditional formatting rules.
Any help greatly appreciated.