谷歌电子表格：价值变化的交替背景颜色？ [英] Google Spreadsheets: Alternating Background Color on Value Change?

问题描述

关于Google Spreadsheets中的条件格式化的主题有很多，但没有像我期待的那样。

所有我要做的是根据列中的值变化设置交替的背景颜色。例如：

如果没有简单的方法来完成这项工作，是否有人知道我会为条件格式公式编写什么？

这些值始终是连续的 - 想法是，着色只是新值上升时的可视助手。

如果你是好奇，我有一个系统类型列表和他们的耗电量 - 我只是想在系统类型改变到正确的屏幕外时有一个颜色分界。

解决方案

我用下面的公式添加了一列：= IF（$ A2 = $ A1，$ D1，$ D1 + 1）

由于我有一个标题行
D，因为这是附加列

比使用以下公式的条件格式化：= isEven（$ D1）

there are lots of topics about Conditional Formatting in Google Spreadsheets, but not one like what I'm looking for.

All I want to do is set an alternating background color based on the value changing in a column. For example:

If there isn't an easy way to accomplish this, does someone know what I'd write for the conditional formatting formula?

The values will always be consecutive - the idea is that the coloring is simply a visual aide for when a new value is up.

If you're curious, I have a list of system types and their power consumption numbers - I would simply like to have a color demarcation for when the system type changes to the right off-screen.

解决方案

I Added an additional column with the following formula: =IF($A2=$A1,$D1,$D1+1)

A2 since I have a header row D since this is the additional column

than conditional formatting on with the following formula: =isEven($D1)

这篇关于谷歌电子表格：价值变化的交替背景颜色？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！