Google表格的条件格式 [英] Conditional formatting google sheets
问题描述
我正在尝试使用自定义公式根据行中"Q"列的值突出显示行.如果q列包含"TRASH",则我想将行涂成红色.就我而言,如您在屏幕快照中所见,并基于我从 https://productforums.google.com/forum/#!topic/docs/WvUSJXrTWUY 我的自定义公式在屏幕截图中.
I'm trying to use a custom formula to highlight a row based on the value of the "Q" column in the row. if the q column contains 'TRASH', I want to colour the row red. In my case , as you can see in the screenshot and based on what I'm getting from https://productforums.google.com/forum/#!topic/docs/WvUSJXrTWUY my custom formula is in the screenshot.
=$Q$8:$Q$8= "TRASH"
格式不起作用.我在做什么错了?
The formatting is not working. What am I doing wrong?
推荐答案
这些条件格式设置将更改文件中行的背景颜色(从单元格A到R),该颜色从第1行开始,一直到最后工作表中的行:
These settings in conditional formatting will change the background color of a row, from cell A to R, in your file It starts at row 1 and goes to the last row in the sheet:
- 适用于范围:A1:R
- 如果...,则设置单元格格式:自定义公式为
- (公式:) = $ Q1 ="TRASH"
根据需要突出显示行设置格式样式. $将公式保存到Q列,但数字前面没有$允许其递增.
Set the Formatting style as you wish to highlight the row. The $ holds the formula to column Q but no $ in front of the number allows it to increment.
请注意,范围将更改为包括工作表的最后一行.
Note that the Range will change to include the last row in your sheet.
这篇关于Google表格的条件格式的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!