How: Conditional formatting primarily based on another mobile in Google Spreadsheets

MY #1 recommendation TO CREATE complete TIME earnings on-line: click here

Conditional layout is a function in Google Spreadsheets in which the cell is formed in a positive way whilst sure situations are met. Layout can encompass highlighting, bold, italic lines – almost any visible exchange to a cellular.

just as it can be achieved for the mobile you are presently in, you may additionally set conditional formatting primarily based on the situations met inside the different cellular.

allow’s delve into how to create this situation primarily based on more than one criteria.

How conditional formatting works

Use this workbook as an instance to learn how to set conditional formatting.

an example of a google sheets workbook showing how conditional formatting works

this is a workbook displaying internet site site visitors from yr to 12 months from the fourth sector of 2020 to the fourth area of 2021, with page views along with an annual percent trade.

here we need to attain the subsequent: when the proportion exchange is high-quality yr-on-yr, the cell turns green. When poor, the cellular turns red. This makes it easy to get a quick evaluate of the operation before delving into the details.

right here are the steps to installation conditional formatting.

1. Pick out the cell you need to format, click on “format” in the navigation bar, and then click “Conditional Formatting.”

how to set the conditional formatting step 1

2. While staying on the “Monochrome” tab, double-test that the cellular beneath “practice to range” is the mobile you want to format. how to set conditional formatting, step 2

3. Set the format rules.

how to set conditional formatting, step 3

it is able to routinely use the same old conditional formatting components through default. In this example, open the drop-down menu beneath “layout cells if» “to select your very own policies. The alternatives will look like this:

four. select a design style and click on “completed”.how to set conditional formatting, step 4

five. Verify that the rule of thumb changed into used within the “Conditional formatting policies” segment.

5th conditional design step

6. If necessary, upload any other rule.

Step 6 of conditional design

7. Go back to the cell to peer the formatting, after which drag the pointer to use it to different cells as wanted.

how to set conditional formatting, step 7

Now that you understand the basics, permit’s have a look at a way to practice conditional formatting based on other cells.

Conditional formatting based totally on another cell cost

1. Choose the cellular you want to layout.

conditional design based on another cell value, step 1

2. Click on “layout” inside the navigation bar, then pick “Conditional formatting”.

conditional design based on another cell value, step 2

3. In the “Formatting rules” section, pick “custom components is.”

conditional design based on another cell value, step 3

4. Write the components and click on “performed”.

conditional design based on another cell value, step 4

5. Confirm that your rule has been applied and test the cell.

conditional design based on other cell value, step 5

Conditional layout primarily based on a distinct variety of cells

To design based totally on a extraordinary range of cells, observe some of the equal steps as you’ll for a cellular fee. What changes is the method you write.

1. Select the cell you want to format.

conditional design based on the second cell range step 1

2. Click on “layout” inside the navigation bar, then pick “Conditional formatting”.

conditional design based on a different range of cells, step 2

3. Inside the “Formatting rules” segment, pick out “custom formulation is.”

conditional design based on a different range of cells, step 3

four. Write the components in the following format: = fee variety [value], pick your layout fashion and click “achieved”.

conditional design based on a different range of cells, step 4

five. Confirm that your rule has been applied and take a look at the cell.

conditional design based on a different range of cells, step 5

Google Sheets Conditional Formatting based on every other mobile color

currently, Google Sheets does now not offer a way to use conditional formatting based at the shade of every other cell. You may handiest use it based on:

  • Values – higher than, extra than, equal to, in between
  • text – consists of, begins with, ends with, suits
  • Dates – is before, is after, is exactly
  • vacancy – is empty, isn’t always empty

To obtain your intention, you’d should use the situation of the cell to layout the alternative.

allow’s use an example.

Google Sheets Conditional Formatting Based on Another Cell Color

Say you want to layout cell A2 (September 2020) to be red and healthy the color of cell E2 (-20%). There’s no formula that permits you to create a circumstance based totally on color. But, you may create a custom formulation based totally on E2’s values.

you may say that if cell E2’s values are less than 0, cell A2 turns purple. The components is as follows: = [The other cell] < [value]. In this situation, the formula could be = e2 <0, as it way that cellular A2 should flip red if the fee of E2 is less than zero.

conditional formatting of Google sheets based on the value of another cell

With such a lot of gaming functions, Google Spreadsheets can appear daunting. By following those simple steps, you can effortlessly layout your cells for a quick experiment.

business templates google sheet

MY number one advice TO CREATE complete TIME income online: click here

Leave a Comment

error: Content is protected !!