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