Quick LinksHide Cell ValuesReplace Zeros With a DashTurn Values to Text Based on a ConditionColor Numbers Based on Their ...

If you want the style to affect all, right click on any worksheet tab to produce this screen: Click on Select All Sheets and whatever formatting you set for that tab will affect all the others. If you ...

Learn how to fix Excel conditional formatting issues with dynamic references, OFFSET function, and defined name method for ...

Q. Every month I have to custom-format 24 worksheets with a complex layout, and it’s tedious doing them one at a time. Is there some way to do it more efficiently? A. Yes, you can group the worksheets ...

Some conditional formattings are a bit special. This includes conditional formatting referring to an external worksheet, databars, Iconsets with customIcons or including 3Stars, 3Triangles or 5Boxes.

Microsoft Excel can’t insert new cells because it would push non-empty cells off the end of the worksheet. These cells might appear empty but have blank values, some formatting, or a formula.

Occasionally when a worksheet is loaded the order in ExcelWorksheet.ConditionalFormatting may be different from the order they were saved in. This is because of how Excel saves the xml and how EPPlus ...