如何编译条件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.
- 选择要着色的范围
- 首页功能区->条件格式->管理规则
- 新规则
- 仅格式化包含的单元格"
- 选择:单元格值&之间
- 输入"0"和"= $ A $ 1"(请记住,没有引号)
- 点击格式->填充,选择黄色
- 点击确定
- 新规则
- 仅格式化包含的单元格"
- 选择单元格值和等于
- 输入"0"
- 点击格式->填充,选择红色
- 点击确定
- 新规则
- 仅格式化包含的单元格"
- 选择单元格值和等于
- 输入"= $ A $ 1"
- 点击格式->填充,选择绿色
- 点击确定
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.
- Select the range you want to be colored
- Home Ribbon -> Conditional Formatting -> Manage Rules
- New Rule
- "Format Only Cells That Contain"
- Choose: Cell Value & between
- Enter in "0" and "=$A$1" (remember, no quotes)
- Click Format -> Fill, choose yellow
- Click Ok
- New Rule
- "Format Only Cells That Contain"
- Choose Cell Value & Equal
- Enter in "0"
- Click Format -> Fill, choose red
- Click Ok
- New Rule
- "Format Only Cells That Contain"
- Choose Cell Value & Equal
- Enter in "=$A$1"
- Click Format -> Fill, choose green
- Click Ok
这篇关于如何编译条件3色阶Excel规则的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!