条件格式：显示一系列的方向箭头 [英] Conditional formatting: Showing direction arrows for a series

问题描述

有人有更快的实现方法吗？

我正在使用Excel 2010。

我有一张桌子，有2列;所有我想要的是一个绿色箭头（向上）或红色箭头（向下），如果右边的值大于/小于左边的值。

不幸的是我只能得到条件格式化在每个单元格上工作（所以当我有15个以上的行时，理论上我必须创建15个规则。有没有更快的方法来创建一些可以轻松复制的系列？ / p>

谢谢！

解决方案

您可以使用帮助单元例如 = IF（A1> B1,1,0），然后为整个表格应用箭头的条件格式，您可能需要调整何时显示箭头但是当我把它放在样品表中时，它默认工作，你可以设置它只显示图标。

I'm using Excel 2010.

Does anyone have a quicker way of implementing this?:

I have a table, with 2 columns; all I want is a green arrow (upwards) or red arrow (downwards) if the value on the right is bigger/smaller than the value on the left.

Unfortunately I can only get condition formatting to work on each individual cell (so when I have 15+ rows, in theory I would have to create 15 'rules'. Is there a quicker way of creating some sort of series that can be easily replicated?

Thank you!

解决方案

You can use a helper cell to with something like =IF(A1>B1,1,0) and then apply the conditional formatting for the arrows for the whole table. You might need to adjust when what arrow shows up but when I threw it in a sample sheet it worked by default. You can set it to show the icon only too.

这篇关于条件格式：显示一系列的方向箭头的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！