如何编译条件3色阶Excel规则 [英] How to compile conditional 3 color-scale Excel rule

问题描述

我想知道我需要在excel的公式框中键入什么才能解决以下问题:

键: * Variable/Cell *

  IF * cellnumber * = 0阴影单元格红色如果* cellnumber *>(大于)0，但<(少于)*单元号*阴影单元黄色如果* cellnumber = * cellnumber *阴影单元格为绿色. 

解决方案

您需要条件格式.在Excel 2007之前的版本中，转到数据"菜单，然后单击条件格式.Excel 2007或更高版本转到主页"功能区，然后单击条件格式".此处是条件格式指南，该指南显示的内容与您所需的内容相似.

对于适用于另一个单元格中值的第二个和第三个条件，您可以在条件格式窗口中放置一个引用，类似于单元格值:等于:"，然后在值框中= $ A $ 1./p>

2011年:下面的任何引号都不应输入.假设您要检查的单元格为A1.

1. 选择要着色的范围
2. 首页功能区->条件格式->管理规则
3. 新规则
4. 仅格式化包含的单元格"
5. 选择:单元格值&之间
6. 输入"0"和"= $ A $ 1"(请记住，没有引号)
7. 点击格式->填充，选择黄色
8. 点击确定
9. 新规则
10. 仅格式化包含的单元格"
11. 选择单元格值和等于
12. 输入"0"
13. 点击格式->填充，选择红色
14. 点击确定
15. 新规则
16. 仅格式化包含的单元格"
17. 选择单元格值和等于
18. 输入"= $ A $ 1"
19. 点击格式->填充，选择绿色
20. 点击确定

I want to know what I would need to type into the formula box in excel to solve the problem outline below:

Key: *Variable/Cell*

IF *cellnumber* = 0 shade cells red
IF *cellnumber* > (more than) 0 but < (less than) *cell number* shade cells yellow
IF *cellnumber = *cellnumber* shade cells green.

解决方案

You want Conditional Formatting. Pre-Excel 2007 go to the Data menu and click conditional formatting. Excel 2007 or later go to the Home ribbon and click Conditional Formatting. Here is a guide to conditional formatting that shows something similar to what you need.

As for the second and third condition that apply to the value in another cell, you can put a reference in the conditional formatting window similar to "Cell Value : Equal to :" then =$A$1 in the value box.

For 2011: Any quotes below should NOT be typed. This assumes the cell you want to check against is A1.

1. Select the range you want to be colored
2. Home Ribbon -> Conditional Formatting -> Manage Rules
3. New Rule
4. "Format Only Cells That Contain"
5. Choose: Cell Value & between
6. Enter in "0" and "=$A$1" (remember, no quotes)
7. Click Format -> Fill, choose yellow
8. Click Ok
9. New Rule
10. "Format Only Cells That Contain"
11. Choose Cell Value & Equal
12. Enter in "0"
13. Click Format -> Fill, choose red
14. Click Ok
15. New Rule
16. "Format Only Cells That Contain"
17. Choose Cell Value & Equal
18. Enter in "=$A$1"
19. Click Format -> Fill, choose green
20. Click Ok

这篇关于如何编译条件3色阶Excel规则的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！