基于两个单元格的Google Sheets条件格式 [英] Google Sheets Conditional Formatting based on two cells

问题描述

我有一张工作表，我想根据两个单元格的值将颜色变成一行.我已经基于要用于两个单元格格式化的单元格中的一个单元格进行了条件格式化. 我正在为两个单元格格式使用= AND($ J:$ J ="Cancel"，$ L:$ L ="Yes")，但它似乎不起作用.不知道第一个= $ J:$ J ="Cancel"是否定另一个的格式，还是我的公式不好. 任何建议将不胜感激.

I have a sheet where I would like to turn a row a color based on the value of two cells. I already have conditional formatting based on one cell of the cells I want to use for the two cell formatting. I am using =AND($J:$J="Cancel",$L:$L="Yes") for the two cell formatting but it doesnt seem to work. Not sure if the first one =$J:$J="Cancel" is negating the formatting of the other or if if my formula is just bad. Any advice would be appreciated.

推荐答案

如果诀窍是您希望整个行都以这种方式着色，那么您只需修改范围"即可对其应用，因此您输入类似开始列的内容，然后将行号指定为范围的后半部分，而无需输入列参数:A1:10001

if the trick is that you want the whole row to be colored that way, then all you need to modify is the "range" to apply it too, so you enter something like the start column and then just give it a row number as the second half of the range, without the column argument: A1:10001

您列出的确切公式=AND($J:$J="Cancel",$L:$L="Yes")在使用自定义公式"选项时对我有用:

That exact formula you listed =AND($J:$J="Cancel",$L:$L="Yes") worked for me when using the "custom formula" option:

这篇关于基于两个单元格的Google Sheets条件格式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！