Trying to format a ledger to highlight alternate months using =ISODD(MONTH($C6)) where C6 is is the uppermost date in an area C6 to J200.
Just the odd months, which get a light blue color, change all format alignments to center. All names and all numbers become center formatted whereas names were left and numbers were right aligned. Delete conditional format and all return to their former format.
Looking at the alignment of these items when shaded blue shows their original alignment left or right - not their new, centered format.
Your CF definition has to name a cell style. Suppose this style is cfOddMonth. If cfOddMonth is set to ‘Alignment’ > ‘Horizontal’ = ‘Centre’ or does inherit this setting from its parent style (Cf. ‘Organiser’ tab of ‘Style’ > ‘Modify’ dialogue) the attribute will be applied under the respective condition.
You should check.
Cells displayed with visual attributes overlayed by CF never show these attributes in the ‘Format Cells…’ dialogue. Neither the style nor the attributes are actually applied to the cells. The effect is only produced for the view “on the fly”.