Ask Your Question

Conditional Formatting - how maintain formatting of cells? [closed]

asked 2017-07-21 17:17:56 +0100

jbk gravatar image

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.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-10 21:07:46.969971

1 Answer

Sort by » oldest newest most voted

answered 2017-07-21 17:44:27 +0100

Lupp gravatar image

updated 2017-07-21 17:54:03 +0100

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".

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2017-07-21 17:17:56 +0100

Seen: 218 times

Last updated: Jul 21 '17