To format cells with a value greater than 400 using a light red fill, which steps are correct?

To format cells with a value greater than 400 using a light red fill, which steps are correct?

• A. Home, Conditional Formatting, Highlight Cells Rules, Greater Than; type 400; choose Light Red Fill.
• B. In the Home tab, click Conditional Formatting > Highlight Cells Rules > Greater Than; type 400 and select Light Red Fill.
• C. Home > Conditional Formatting > Color Scales > Red-White; Greater Than 400.
• D. Home > Conditional Formatting > Data Bars > Greater Than; 400.

Answer: (B)

Using conditional formatting to highlight cells based on a value lets you automatically change how a cell looks when it meets a specific condition. To format cells with values greater than 400 using a light red fill, you set a Greater Than rule with the threshold 400 and choose the Light Red Fill style. The exact path is: In the Home tab, click Conditional Formatting > Highlight Cells Rules > Greater Than; type 400 and select Light Red Fill. This works because the rule compares each cell’s numeric value to 400 and applies the chosen fill only when the condition is true, giving a clear visual cue for numbers above 400. Other options apply different types of formatting (like color scales or data bars) that don’t produce a single flat fill for every cell based on a simple greater-than condition.

Using conditional formatting to highlight cells based on a value lets you automatically change how a cell looks when it meets a specific condition. To format cells with values greater than 400 using a light red fill, you set a Greater Than rule with the threshold 400 and choose the Light Red Fill style. The exact path is: In the Home tab, click Conditional Formatting > Highlight Cells Rules > Greater Than; type 400 and select Light Red Fill. This works because the rule compares each cell’s numeric value to 400 and applies the chosen fill only when the condition is true, giving a clear visual cue for numbers above 400. Other options apply different types of formatting (like color scales or data bars) that don’t produce a single flat fill for every cell based on a simple greater-than condition.