许多行中每一行的最大值的条件格式 [英] Conditional Formatting of maximum value in each row of many
问题描述
我有一个包含250多个数据行的电子表格,需要在每一行中找到最大值.我尝试使用条件格式,但是我需要为每行使用相同的规则,因此不能突出显示所有数据,并且尝试复制和粘贴它会很麻烦.
I have a spreadsheet with 250+ rows of data and need to find the largest value in each row. I tried to use Conditional Formatting, however I need the same rule for each row so can't highlight all the data, and trying to copy and paste it would be too cumbersome.
是否有更快的方法将相同的规则分别应用于每一行?
Is there a faster way of applying the same rule to each row separately?
推荐答案
请选择相关列(例如A:H)和首页">样式-条件格式,新规则...,使用公式来确定哪个单元格要格式化和在此公式为真的情况下格式化值::
Please select he relevant columns (say A:H) and HOME > Styles - Conditional Formatting, New Rule..., Use a formula to determine which cells to format and Format values where this formula is true::
=A1=MAX($A1:$H1)
格式... ,选择格式选择,确定,确定.
Format..., select your choice of formatting, OK, OK.
如果您希望在行中没有任何值时停止格式化,请调整为:
If you want the formatting to stop when there are no values in the row adjust to:
=AND(COUNT($A1:$H1)<>0,A1=MAX($A1:$H1))
这篇关于许多行中每一行的最大值的条件格式的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!