How do you highlight a cell based on another cell that is blank?

How do you highlight a cell based on another cell that is blank?

Apply conditional formatting if another cell is blank

1. First of all, select the range that you want to highlight, this will save you some steps later.
2. Click on Conditional formatting at the top and choose “New rule”.
3. Now you can enter your custom condition and set the desired format.
4. Click Ok and here you go.

How do you make a cell a color until data is entered?

Select a range of blank cells you need to shade until something is entered, and then click Home > Conditional Formatting > New Rule.

How do I color empty cells in Excel?

Here are the steps to select and highlight blank cells in Excel:

1. Select the data.
2. Press the F5 key.
3. In the Go To dialog box, click on the Special button.
4. In the Go To Special dialog box, select Blanks.
5. Click OK.
6. With all the blank cells selected, highlight these by giving it a cell color.

How do you color empty cells in Excel?

With this method you can quickly color the empty cells in the worksheet. 1. Select the specified range where you will shade all blank cells (or nonblank cells). 2. Click Home > Find & Select > Go To Special…to open the Go To Special dialog box. And then check the Blanks option in this dialog box, see screenshot:

How to shade or color blank cells or nonblank cells in Excel?

Shade all blank/nonblank cells with Conditional Formatting. 3. In the opening dialog box, please click Use a formula to determine which cells to format in the Select a Rule Type box, and enter the formula =A1= “” (A1 is the first cell in the specified range) into the Format values where this formula is true box,…

How to use conditional formatting for blank cells in Excel?

Conditional Formatting for Blank Cells is the function in excel which is used for creating inbuilt or customized formatting. From this, we can highlight the duplicate, color the cell as per different value range, etc. It has also a way to highlight blank cells. Start Your Free Excel Course.

How do you change the color of a row in Excel?

How to change a row color based on a number in a single cell. This can be easily done using Excel Conditional Formatting. Start with selecting the cells the background color of which you want to change. Create a new formatting rule by clicking Conditional Formatting > New Rule… on the Home tab.