Home

(Help) Rules of CONDITIONAL FORMATTING change after reopening EXCEL

%3CLINGO-SUB%20id%3D%22lingo-sub-422025%22%20slang%3D%22en-US%22%3E(Help)%20Rules%20of%20CONDITIONAL%20FORMATTING%20change%20after%20reopening%20EXCEL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-422025%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI%20encountered%20a%20problem%20when%20using%20DATA%20BAR%2C%20one%20of%20conditional%20formatting.%3C%2FP%3E%3CP%3EI%20changed%20the%20default%20rule%20for%20specific%20cells%20to%20make%20bars%20look%20better.%3C%2FP%3E%3CP%3EHowever%2C%20after%20reopening%20excel%2C%20rules%20and%20corresponding%20bars%20changed.%3C%2FP%3E%3CP%3EI%20wondered%20if%20there%20is%20a%20way%20to%20fix%20the%20rule%20so%20that%20bars%20remain%20same%20before%20and%20after%20reopening%20excel.%3C%2FP%3E%3CP%3EGreatly%20appreciate%20for%20your%20help.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-422025%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-429626%22%20slang%3D%22en-US%22%3ERe%3A%20(Help)%20Rules%20of%20CONDITIONAL%20FORMATTING%20change%20after%20reopening%20EXCEL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-429626%22%20slang%3D%22en-US%22%3EProvided%20that%20you%20saved%20the%20file%2C%20the%20bars%20should%20look%20as%20they%20were%20when%20you%20saved.%20If%20not%2C%20can%20you%20provide%20screen-shots%20before%20saving%20and%20after%20saving%2C%20closing%20and%20opening%20the%20file%20again%3F%20Possibly%20include%20the%20Excel%20file%20as%20well%3F%3C%2FLINGO-BODY%3E
Molis112
Occasional Visitor

Hi, 

I encountered a problem when using DATA BAR, one of conditional formatting.

I changed the default rule for specific cells to make bars look better.

However, after reopening excel, rules and corresponding bars changed.

I wondered if there is a way to fix the rule so that bars remain same before and after reopening excel.

Greatly appreciate for your help. 

1 Reply
Provided that you saved the file, the bars should look as they were when you saved. If not, can you provide screen-shots before saving and after saving, closing and opening the file again? Possibly include the Excel file as well?
Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies