Formulas Data SIMS Sharo 1.00 Point: XL Activity 2.10: Applying Conditional Formatting by Using Highlight Cells Rules and Data Bars 2 Logical File Home Insert Page Layout fx AutoSum - Recently Used - Text Insert Function Financial Date & Time Function Library Is Lookup & Reference Math & Trig More Functions 2A_Custom_Products - Excel Review View Tell me what you want to do... Dafina Name - Trace Precedents 51 Use in Formula Trace Dependents Name Manager Create from Selection Remove Arrows. Defined Names Formule Auditing Calculation Watch Window Options Calculation H 1 Apply conditional formatting to the selected range F15:F44, so that if a cell within the range contains the word Discontinue, the cell text will be formatted with a Dark Red font color-in the first column, the first color under Standard Colors. Apply conditional formatting to display gradient fill red data bars in the range D15:044 FIS f =IF(D15 Attempts Remaining: 3 E View All C Reset Data Save Submit + Ready + 100% Formulas Data SIMS Sharo 1.00 Point: XL Activity 2.10: Applying Conditional Formatting by Using Highlight Cells Rules and Data Bars 2 Logical File Home Insert Page Layout fx AutoSum - Recently Used - Text Insert Function Financial Date & Time Function Library Is Lookup & Reference Math & Trig More Functions 2A_Custom_Products - Excel Review View Tell me what you want to do... Dafina Name - Trace Precedents 51 Use in Formula Trace Dependents Name Manager Create from Selection Remove Arrows. Defined Names Formule Auditing Calculation Watch Window Options Calculation H 1 Apply conditional formatting to the selected range F15:F44, so that if a cell within the range contains the word Discontinue, the cell text will be formatted with a Dark Red font color-in the first column, the first color under Standard Colors. Apply conditional formatting to display gradient fill red data bars in the range D15:044 FIS f =IF(D15 Attempts Remaining: 3 E View All C Reset Data Save Submit + Ready + 100%