F5F Stay Refreshed Software Operating Systems Excel - Format RulesConditional formatting in Excel helps highlight data based on specific conditions.

Excel - Format RulesConditional formatting in Excel helps highlight data based on specific conditions.

Excel - Format RulesConditional formatting in Excel helps highlight data based on specific conditions.

S
Suqerb
Junior Member
23
12-18-2020, 02:58 AM
#1
Hi, I'm having trouble with MS Excel (Office 365). Some cells contain numbers and I used conditional formatting to show them. After saving and reopening the file, the formatting changed unexpectedly. This only occurs in certain files—recreating a new file doesn't fix it. I don’t want to move all my sheets, so someone might know how to resolve this. For reference, I’ve set up a new sheet in my Excel document. You can watch a video explaining the problem here: http://a.pomf.se/fgukog.webm. Thank you!
S
Suqerb
12-18-2020, 02:58 AM #1

Hi, I'm having trouble with MS Excel (Office 365). Some cells contain numbers and I used conditional formatting to show them. After saving and reopening the file, the formatting changed unexpectedly. This only occurs in certain files—recreating a new file doesn't fix it. I don’t want to move all my sheets, so someone might know how to resolve this. For reference, I’ve set up a new sheet in my Excel document. You can watch a video explaining the problem here: http://a.pomf.se/fgukog.webm. Thank you!