Excel 使用操作汇总

发表于 分类于 阅读次数： 本文字数： 1.2k 阅读时长 ≈ 1 分钟

条件格式 conditional formatting

You can use conditional formatting in Excel to change the background color of cells based on a condition. Here's how you can do it to change the background color to red if the unit value in a cell is greater than 0.04:

  1. Select the cell or range of cells where you want to apply the conditional formatting.

  2. Go to the "Home" tab in the Excel ribbon.

  3. In the "Styles" group, click on "Conditional Formatting."

  4. Choose "New Rule" from the dropdown menu.

  5. In the "New Formatting Rule" dialog box, select "Use a formula to determine which cells to format."

  6. In the "Format values where this formula is true" field, enter the following formula:

    1
    =A1>0.04

    Note: Replace "A1" with the reference to the cell you want to apply this rule to. If you are formatting a range of cells, adjust the formula accordingly.

  7. Click the "Format" button to set the formatting for cells that meet the condition.

  8. In the "Format Cells" dialog box, go to the "Fill" tab.

  9. Choose the red color you want for the background from the color palette.

  10. Click "OK" to confirm the formatting.

  11. Back in the "New Formatting Rule" dialog box, you will see a preview of how the formatting will look. Make sure it's what you want.

  12. Click "OK" to apply the conditional formatting rule.

The selected cells will now have a red background if the unit value is greater than 0.04. You can adjust the formula and formatting settings as needed for your specific Excel sheet.