Conditional formatting is a characteristic in Google Sheets through which a cellular is formatted in a specific means when sure stipulations are met. The formatting can come with highlighting, bolding, italicizing – with regards to any visible adjustments to the cellular.
Simply as it may be finished for the cellular you’re these days in, conditional formatting may also be set in response to stipulations met in any other cellular.
![→ Access Now: Google Sheets Templates [Free Kit]](https://wpfixall.com/wp-content/uploads/2022/01/e7cd3f82-cab9-4017-b019-ee3fc550e0b5.png.webp)
Let’s dive into find out how to create this situation in response to a couple of standards.
How Conditional Formatting Works
To discover ways to set conditional formatting, let’s use this workbook for instance.
It’s a workbook appearing web site site visitors yr over yr from This autumn 2020 to This autumn 2021, with the web page perspectives along side the year-over-year proportion alternate.
Right here’s what we wish to accomplish right here: When the proportion alternate is certain YoY, the cellular turns inexperienced. When it’s detrimental, the cellular turns purple. This makes it simple to get a handy guide a rough efficiency review ahead of diving into the main points.
Listed here are the stairs to set the conditional formatting.
1. Choose the cellular you wish to have to structure, click on on “Layout” from the navigation bar, then click on on “Conditional Formatting.”
2. Whilst staying within the “Unmarried colour” tab, double-check that the cellular below “Practice to vary” is the cellular you wish to have to structure. 
3. Set your structure regulations.
It’ll robotically default to a normal conditional formatting method. On this case, open the dropdown menu below “Layout cells if…” to make a choice your regulations. Choices will glance as follows:
4. Select your formatting taste, then click on “Completed.”
5. Ascertain the guideline used to be carried out below “Conditional Formatting Regulations.”
6. Upload any other rule if wanted.
7. Go back to cellular to view formatting, then drag the cursor to use to different cells, if wanted.
Now that you know the fundamentals, let’s duvet find out how to use conditional formatting in response to different cells.
Conditional Formatting According to Every other Cellular Worth
1. Choose the cellular you wish to have to structure.
2. Click on on “Layout” within the navigation bar, then make a choice “Conditional Formatting.”
3. Beneath “Layout Regulations,” make a choice “Customized method is.”
4. Write your method, then click on “Completed.”
5. Ascertain your rule has been carried out and examine the cellular.
Conditional Formatting According to Every other Cellular Vary
To structure in response to any other cellular vary, you practice lots of the similar steps you possibly can for a cellular price. What adjustments is the method you write.
1. Choose the cellular you wish to have to structure.
2. Click on on “Layout” within the navigation bar, then make a choice “Conditional Formatting.”
3. Beneath “Layout Regulations,” make a choice “Customized method is.”
4. Write your method the use of the next structure: =price vary < [value], make a choice your formatting taste, then click on “Completed.”
5. Ascertain your rule has been carried out and examine the cellular.
Google Sheets Conditional Formatting According to Every other Cellular Colour
Recently, Google Sheets does no longer be offering some way to make use of conditional formatting in response to the colour of any other cellular. You’ll simplest use it in response to:
- Values – upper than, more than, equivalent to, in between
- Textual content – incorporates, begins with, ends with, fits
- Dates – is ahead of, is after, is strictly
- Vacancy – is empty, isn’t empty
To reach your purpose, you’d have to make use of the situation of the cellular to structure the opposite.
Let’s use an instance.
Say you wish to have to structure cellular A2 (September 2020) to be purple and fit the colour of cellular E2 (-20%). There’s no method that lets you create a situation in response to colour. Then again, you’ll be able to create a customized method in response to E2’s values.
You’ll say that if cellular E2’s values are not up to 0, cellular A2 turns purple. The method is as follows: = [The other cell] < [value]. On this case, the method could be =e2<0, because it implies that cellular A2 will have to flip purple if E2’s price is not up to 0.
With such a lot of purposes to play with, Google Sheets can appear daunting. Via following those easy steps, you’ll be able to simply structure your cells for speedy scanning.
