How to fill black cells with color using conditional formatting in excel | Conditional Formatting in Excel

How to fill black cells with color using conditional formatting in excel | Conditional Formatting in Excel

Step1:   Select the range of cells in excel sheet and click                                  on  conditional formatting in excel and select new rule                     which is shown in figure.

How to fill black cells with color using conditional formatting in excel | Conditional Formatting in Excel

Step 2:   A window will open when u click on new rule, in that new rule windows select "format only cells that contain".

In below edit rule description, select " Blanks"

How to fill black cells with color using conditional formatting in excel | Conditional Formatting in Excel

Then click on format and a new windows will open 

Step 3:  Go to fill in format window and select color and press ok

How to fill black cells with color using conditional formatting in excel | Conditional Formatting in Excel

Now you can see the applied color in the selected range of cells if the cells are blank. If you type any data in cells color it automatically changes to default.