Question

Create a formula for sheet Inventory that highlights any rows where the Reorder level is below the On Hand level in yellow on excel 2016. Will mark brainliest if you can tell me how.

Answer 1

Answer:

Highlight the actual inventory level column and click on condition formatting, click on the drop-down button and select "Formula is" to input the formula "=B4 <= C4", select the color pattern to format the row if the condition is met and click ok.

Explanation:

Assuming the reorder level (column C4 and the on-hand level or actual inventory (column B starting at row 4) are columns in the Excel worksheet. The reorder level is the minimum level of inventory before inventory is populated. So the formula compares the value of the actual level with the reorder level, if any row is less than or equal to the reorder level, the row is formatted with the selected color.

Answer 2

Answer:

Highlight the actual inventory level column and click on condition formatting, click on the drop-down button and select "Formula is" to input the formula "=B4 <= C4", select the color pattern to format the row if the condition is met and click ok.

Explanation: