To have the knowledge of Conditional formatting is very important if we want to apply GOOGLE SHEETS in our day to day jobs.
Conditional formatting is the formatting [ font, color, fill color , size etc. ] of data as per its value of the content of the cells.
The ways of using CONDITIONAL FORMATTING in GOOGLE SHEETS is already discussed in the article HOW TO USE CONDITIONAL FORMATTING IN GOOGLE SHEETS?. [ CLICK HERE TO VISIT THE ARTICLE ].
A situation may arise when we need to simply copy the already applied conditional formatting rules for some new data. For this situation , we’ll discuss the various ways using which we can copy the conditional formatting rules easily from one data to other without affecting its efficacy.
YOU ARE SUPPOSED TO BE HAVING THE NECESSARY KNOWLEDGE ABOUT THE APPLICATION OF CONDITIONAL FORMATTING IN GOOGLE SHEETS. IF NOT CLICK HERE.
THE CONDITIONAL FORMATTING CAN BE COPIED DIRECTLY IN TWO WAYS
1. Using the CONDITIONAL FORMATTING COPY option.
2. Editing the APPLY TO RANGE data directly.
Let us take an example for learning the ways to copy conditional formatting.
Let us take attendance of two different classes of students.
We’ll highlight the week when the attendance was between 90 to 95 percent.
We’ll copy the CONDITIONAL FORMATTING rules for CLASS 2 directly using our two methods.
The first step is to apply the CONDITIONAL FORMATTING and highlight the Week with attendance percentage between 90 and 95.
STEPS TO APPLY CONDITIONAL FORMATTING ON THE DATA OF CLASS 1.
The following picture shows all the settings.
The following picture depicts the process of pasting the conditional formatting.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE