Ask Your Question
0

Conditional Formatting - how maintain formatting of cells?

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 close merge delete

1 Answer

Sort by » oldest newest most voted
0

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 146 times

Last updated: Jul 21 '17