Google Sheets特定列条件格式设置求助：从D列第8行开始配置

Hey there! As someone new to Google Sheets, setting up this conditional formatting for your D column (starting at row 8) is totally straightforward. Let’s walk through it step by step:

Step 1: Select the Target Range #

First, click cell D8, then drag your cursor down to cover all the cells you want this formatting to apply to. If you want it to automatically work for new rows added later, you can select the entire column starting at D8 by clicking D8 and pressing Ctrl+Shift+Down (Windows) or Cmd+Shift+Down (Mac) — or just type D8:D into the name box at the top-left of the sheet.

Step 2: Open the Conditional Formatting Panel #

Head to the top menu bar, click Format > Conditional formatting. This will pull up a sidebar on the right side of your sheet.

Step 3: Add the 'pass' Rule #

In the conditional formatting sidebar:

• Under "Format cells if", pick Custom formula is from the dropdown.
• In the formula box, enter:

  =ISNUMBER(SEARCH("pass", D8))
  

  (This checks if the cell contains "pass" — it’s case-insensitive, so "Pass" or "PASS" will also trigger it. If you need strict case matching, use =EXACT(D8, "pass") instead.)
• Click the Fill color icon, select Custom at the bottom of the color picker, input the RGB values 183, 225, 205, and hit OK.
• Click Done to save this rule.

Step 4: Add the 'fail' Rule #

Click the Add another rule button in the sidebar:

• Again, choose Custom formula is.
• Enter this formula:

  =ISNUMBER(SEARCH("fail", D8))
  

• Set the fill color to custom RGB 213, 139, 139 and save the rule.

Step 5: Add the 'pending' Rule #

Click Add another rule once more:

• Select Custom formula is.
• Input:

  =ISNUMBER(SEARCH("pending", D8))
  

• Set the fill color to custom RGB 252, 232, 178 and save the rule.

How It Works #

Once these rules are set up, any time you edit a cell in D8:D, Google Sheets will automatically check the content against the rules and apply the right background color instantly. No extra steps required — it’s all real-time!

Quick Tip #

If you ever need to tweak the rules (like changing colors or adjusting match criteria), just go back to Format > Conditional formatting, find the rule in the sidebar, and click the pencil icon to edit it.

内容的提问来源于stack exchange，提问作者Edil