The following steps would apply conditional formatting to the range:
- Select the range of cells C6 : C41
- Click Conditional Formatting on the Home tab
- Set the condition
- Point to Color Scales, and then select the font color as red color
How to apply the conditional formatting?
The given parameters in the question are:
- Range = C6 : C41
- Condition = cell that are greater than or equal to 50.
- Action = font color as red color
The Conditional Formatting is located on the home tab
So, the first step to select the range and locate the Conditional Formatting option
Then set the necessary conditions and formats
Read more about conditional Formatting at
brainly.com/question/4414551
#SPJ1
