根据相邻的下拉值更改Excel中的单元格颜色 [英] Change cell color in Excel according to adjacent dropdown value
问题描述
A1
是一个否/是
下拉列表
B1
是一个标准语句
如果用户满足 B1
中的条件语句他们在 A1
的下拉列表中选择是
。为了快速参考,如果可能,我希望 B1
在此事件上更改为绿色背景颜色,如果下拉菜单重置,当然更改为无填充到否
。
这可能在Excel 2003和/或2007?
在Excel 2007,2010或2013中,尝试
- 首页标签选择条件
格式 - >新规则
- 使用使用公式确定
要格式化的单元格
- 对于单元格B1公式可以是
=(A1 =是),并将
格式的颜色更改为
希望。
- 然后可以扩展格式
从B1到B?根据需要。
I understand how to make a dropdown list. I understand how to make conditional formatting change the color of a cell. What I do not understand is how to make conditional formatting change the color of a cell based solely on the state of another cell (not a comparison).
A1
is a No / Yes
dropdown list
B1
is a criteria statement
If the user satisfies the criteria statement in B1
, they select Yes
on the dropdown list in A1
. For quick reference, if possible, I'd like B1
to change to a green background color on this event, and of course change back to no-fill if the dropdown is reset to No
.
Is this possible in Excel 2003 and/or 2007?
In Excel 2007, 2010 or 2013, try
- Under the home tab select Conditional Formatting -> New Rule
- Use the Use a formula to determine which cells to format
- For Cell B1 the formula can be "=(A1="Yes")", and change the formatting back color to what you wish.
- You can then extend the formatting from B1 to B? as required.
这篇关于根据相邻的下拉值更改Excel中的单元格颜色的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!