User Posts: Maruf Islam
Timeline Charts are charts or graphs that depict the chronological execution of partial events of a much bigger event. For numerous reasons, users need to ...
When product sellers or producers try to predict amounts or values of future outcomes depending on two or multiple criteria have to conduct Regression Analysis ...
When users send emails to their customers or bosses it’s quite hard to keep track. In that case, Excel comes in handy. Therefore, "send automatic email from ...
Sometimes, while working in Excel, users encounter- an “Excel file opens but does not display” issue. Not knowing the last Excel operation, enabled Hardware ...
In Excel, users execute sensitive calculations which need to be unaltered once calculated. As a result, the Excel lock cell value once calculated is a handy ...
Users use passwords to protect their Excel files or worksheets. Unfortunately, there are numerous cases where users also forget their passwords. As a result, ...
Excel user interface holds multiple Tabs, Groups/Sections, Command Menus, Commands, Dialog Boxes, and a single Pin or Unpin Toggle. This combination of Tabs ...
Using absolute values to differentiate incidents such as Loss, Gain, Due, etc. is pretty common among users. Excel absolute difference between two numbers is ...
Excel does numerous things, working as a Customer Database is one of them. If users follow a couple of operations, it's easy to maintain the Customer Database ...
In day-to-day life, we often need cross-use data from different applications. Data fetching or importing from Microsoft Word to Excel or vice versa is a daily ...
Comma-separated values (CSV) files are the raw forms of data files users tend to save as. It’s common among users to Excel import CSV into an existing sheet to ...
Working with PDFs in Excel is common among users. PDF printing is one of the repetitive instances users find themselves in. Excel print to PDF Macro Button can ...
PDFs are almost non-editable documents used for multiple purposes. It’s common among users to convert from PDF to Excel. However, there are numerous free ...
Pivot Tables are effective when it comes to sorting or grouping data. In general, Pivot Tables adds an extra field as Subtotal when it displays any dataset as ...
Sometimes, users encounter identical Excel files or want to compare between files. In that case, Excel View Side by Side is very useful. However, in some ...
- 1
- 2
- 3
- …
- 9
- Next Page »
Thanks for your appreciation @Ed
You can exclude or ignore the blanks using 2 simple tricks.
1. Use an additional formula in conditional formatting. Go to conditional formatting > New Rule option > select Format Only Cell that contains rule type > Select Blanks from edit rule description > Keep Cell format as no cell format. Click OK.
2. Go to Conditional formatting > New Rule option> Select Use a formula to determine which cell to format rule type > type “=ISBLANK(Cell Reference)=TRUE” in the Edit the Rule description box > Keep Cell format as no cell format. Click OK.
Hope these tricks work for you.