Question

In the cell range C3:J26, apply conditional formatting so that cells that contain values over 200,000 display with green fill and text and values under 10,000 display with a red border.

Answer 1

To apply conditional formatting to the cell range C3:J26 in Excel, select the range and go to the Conditional Formatting menu. Choose 'Format only cells that contain' and set the conditions for values over 200,000 and under 10,000. Apply the desired formatting options and click 'OK' to apply the formatting.

Step-by-step explanation:

To apply conditional formatting to the cell range C3:J26, follow these steps:

1. Select the cell range C3:J26.
2. Go to the 'Home' tab in the Excel ribbon.
3. Click on the 'Conditional Formatting' button.
4. Select 'New Rule' from the drop-down menu.
5. In the 'New Formatting Rule' dialog box, choose 'Format only cells that contain'.
6. In the first drop-down menu, select 'Greater than'.
7. In the second text box, enter '200000'.
8. Click on the 'Format' button and choose the desired fill color and font color for values over 200,000.
9. Click on 'OK' to apply the formatting.
10. Repeat steps 4-9, but this time choose 'Less than' in step 6 and enter '10000' in step 7. Choose the desired border color for values under 10,000.
11. Click on 'OK' to apply the formatting.