Take Conditional Formatting To Next. If there are rules in the row already just directly jump to the step 4. Once we do that we will get the drop-down list of Conditional Formatting.
Click the first cell or range of cells that the conditional formatting is to be applied to. You had the same conditions applied to two different ranges. The cell is filled with the color you selected for the conditional formatting rule for dates more than 30 days past due.
Click the last option.
Starts from Cell A4 will check whether the cell E4 has the delivery Status Pending or not. With the cursor still in the cell or range select Conditional formatting Manage rules for Current selection screenshot at top of page. Here we will be using the same formula with a slight change. To convert conditional formatting to staticwe will first convert Excel to Htmlwebpage and then back to excel.