question archive In cell G15 construct an IF function to determine the items that must be ordered
In cell G15 construct an IF function to determine the items that must be ordered
Subject:Computer SciencePrice: Bought3
In cell G15 construct an IF function to determine the items that must be ordered . If the Quantity in Stock is less than 75 , the Value if_true is Order. Otherwise , the Value if false is OK . Fill the formula down through all the rows Without grouping the worksheets , apply conditional formatting as follows to both worksheets . Apply Conditional Formatting to the Stock Level column so that cells that contain the text Order are formatted with Bold Italic font color set to Automatic, and Fill color set to No Color. . Apply Gradient Fill Blue Data Bars to the Quantity in Stock column
