Conditional Formatting in Pivot table

Original Question:- How to replace blanks in Pivot Table with alternative text? I can use a custom conditional format to remove (blank) from a P...

Format Painter to Copy Column Width & Row Height in Microsoft Excel

In this article, we will learn how to use the format painter to copy column widths and row heights in Microsoft Excel. Format Painter is a basic fe...

How to Hide the Zero (0) Values in Excel

In this article, we will learn How to Hide the Display of Zero Values in Excel. Scenario: Problem here is working with excel data, sometimes...

Changing the Default Style in Microsoft Excel 2010

In this article, we will learn how to change the default style in Excel. You can customize excel the way you want to use on a daily basis. If you fin...

How to Color Numbers based on the Value Result in Excel

In this article, we will learn How to Color numbers based on the Value Result in Excel. Scenario: Formatting is only for the viewer's ...

Displaying the Format Cells Dialog Box in Microsoft Excel 2010

In this article, we will learn how we can display the format cells dialog box in Microsoft Excel 2010. We can find this option by right clicking with ...

Color Unique Record in a Range in Microsoft Excel

In this article, we will learn how to color unique record in a range. We use the Conditional Formatting option along with COUNTIF function in Microsof...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.