根据列的值着色完成行 [英] Coloring complete Row based on values from Columns
问题描述
我需要根据列中单元格的值对完整的Excel行进行着色。
I need to color the complete Excel row based upon the value of a cell in column.
我有三列( Item
,价格
和状态
),如果状态
值为:
I have three columns (Item
, Price
and Status
) and want to color the row if the Status
value is:
- DELIVERED(以绿色)
- REJECTED (到红色)
- WIP(到橙色)
推荐答案
您可以使用(非VBA)条件格式化
You can use (non-VBA) conditional formatting for this
如果您的Status列位于列C中,则 - 已选择区域中的所有行兴趣 - 您可以使用这样的规则来根据列C条目格式化整行。
If your Status column was in column C then - having selected all the rows in the area of interest - you can use rules such as this to format the entire row based on the column C entries
= $ C1 =REJECTED
并选择红色
= $ C1 =WIP
并选择橙色等
=$C1="REJECTED"
and pick Red
=$C1="WIP"
and pick Orange etc
更改您的列参考符合
下面的示例来自Excel 2010
The sample below is from Excel 2010
{NB:如果需要,请更改文字大小}
S ee Debra Dalgleish的网站了解更多详情
See Debra Dalgleish's site for more detail
这篇关于根据列的值着色完成行的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!