I have a spreadsheet where I want to search for the word "Total" in column headings, then look down the column that matched for "Total", find any row that has a value greater than 1 and highlight the row. The reason for searching for "Total" is that more columns may be added at any time but there will always be a "Total" column, and I will always want to highlight that row if the total is greater than 0.
我有一个电子表格,我想在列标题中搜索单词“Total”,然后向下看匹配“Total”的列,找到值大于1的任何行并突出显示该行。搜索“总计”的原因是可以随时添加更多列,但总会有“总计”列,如果总计大于0,我将始终要突出显示该行。
I got very confused using the MATCH function.
我使用MATCH函数感到非常困惑。
I have a sample spreadsheet but can't see how to upload it.
我有一个示例电子表格,但无法看到如何上传它。
1 个解决方案
#1
0
With a warning that I either misunderstood the requirement or now misunderstand it and assuming column headings are in Row1, please try selecting the entire sheet and HOME > Styles - Conditional Formatting, New Rule..., Use a formula to determine which cells to format and Format values where this formula is true::
警告我要么误解了要求,要么现在误解它并假设列标题在Row1中,请尝试选择整个工作表和HOME>样式 - 条件格式,新规则...,使用公式确定要格式化的单元格和此公式为true的格式值::
=OFFSET($A1,,MATCH("Total",$1:$1,0)-1)>0
Format... with formatting of your choice, OK, OK.
格式化......使用您选择的格式,确定,确定。
#1
0
With a warning that I either misunderstood the requirement or now misunderstand it and assuming column headings are in Row1, please try selecting the entire sheet and HOME > Styles - Conditional Formatting, New Rule..., Use a formula to determine which cells to format and Format values where this formula is true::
警告我要么误解了要求,要么现在误解它并假设列标题在Row1中,请尝试选择整个工作表和HOME>样式 - 条件格式,新规则...,使用公式确定要格式化的单元格和此公式为true的格式值::
=OFFSET($A1,,MATCH("Total",$1:$1,0)-1)>0
Format... with formatting of your choice, OK, OK.
格式化......使用您选择的格式,确定,确定。