在表中的任何位置自动为特定值上色 [英] Automatic colouring of a specific value wherever found in a table

问题描述

我正在寻找一种自动更改Google表格中一行中最小单元格颜色的方法.因此，对于像这样的表:

I am looking for a way to automatically change the color of the minimum cell in a row in Google Sheets. So, for a table like:

1 | 2 | 3
4 | 2 | 1
2 | 1 | 6

它将为所有带有1的单元格着色.

it would color all the cells with 1 in them.

推荐答案

在下拉菜单中，格式->条件格式...

In the dropdown menu, Format->Conditional formatting...

然后设置规则和颜色.您可以选择多个单元格，也可以这样做.

Then set your rules and your color. You can select multiple cells and do this also.

这就是您可以进行着色的程度.您可能会找到一个复杂的公式来查找最小的单元格，然后如果与该单元格中的内容匹配，则为其上色，但是如果这对您来说很重要，则可能要使用Excel而不是Google文档.

That is the extent of what you can do with coloring. You can maybe find a complex formula to find the minimum of the cells, and then if that matches what is in the cell, then color it, but you may want to use Excel instead of Google docs if this is a critical thing for you.

这篇关于在表中的任何位置自动为特定值上色的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！