How do I Conditional Format based on another cell in Google Sheets?

Select the cells that have the names (A2:A11). Go to the Format Tab. Click on Conditional Formatting. In the Conditional Formatting rules pane, select Single Color. From the 'Format Cells if' drop down, select 'Custom Formula is'.

Can you conditional format a cell based on another cell?

When you want to format a cell based on the value of a different cell, for example to format a report row based on a single column's value, you can use the conditional formatting feature to create a formatting formula.

How do I change cell color based on value in another cell?

Select the cells that have the names (A2:A11). Go to the Format Tab. Click on Conditional Formatting. In the Conditional Formatting rules pane, select Single Color. From the 'Format Cells if' drop down, select 'Custom Formula is'.

How do I apply conditional formatting to other cells?

Copying Conditional Formatting to Another Cell Click on the cell that has the conditional formatting you want to copy. Click Home > Format Painter. To paste the conditional formatting, drag the paintbrush across the cells or ranges of cells you want to format.

Can you conditional format a row based on one cell?

You can apply conditional formatting that checks the value in one cell, and applies formatting to other cells, based on that value. For example, if the values in column B are over a set value, make the row blue.

Modify Conditional Fields to Document for Sign in Google Drive For Free

Last updated on Sep 14, 2026

Try most popular PDF tools

Discover a full set of tools to handle any document task.

Edit PDFs

Make quick PDF edits online.

Sign

Add legally binding signatures.

Merge

Combine multiple PDFs.

Request signatures

Send a document for signing.

Convert

Transform PDFs into other formats.

Find form online

Browse the online forms library.

Rearrange

Change the order of pages.

Share

Send PDFs for review or editing.

Compress

Reduce PDF file sizes.

pdfFiller ranks among the best

pdfFiller is rated 4.6 out of 5 stars across 1,000+ G2 reviews.

Read all reviews

They were awesome when I needed them to most!

Danna R. M

People want to type into box which needs signed into is one problem another is email comes from PDF filler and a lot of people don't know I'm one sending stuff to be signed

Jason M