![]() The above setting will only highlight the first column in the matching tables. Under the ‘Formatting style’, I have set ‘Light Grey’ as the cell background color and ‘Red Berry’ as the font color. ![]() If you have any doubt to enter the rule (formula) and the range to highlight in ‘Apply to range’, please refer to the screenshot below. To enter the above formula, select ‘Custom formula is’. If not, enter the range B3:J10 in the given field. Inside the ‘Conditional format rules’ panel, you can see that the ‘Apply to range’ is set to B3:J10. Select the range B3:J10 and go to Conditional formatting. Inserting Custom Formula (Rule) in Conditional Formatting (Formant Menu) #Table cell colo g docs how toFor that, before applying the rule, select the range B3:Z100 instead of B3:J10.įirst, let us learn how to apply the above formula to highlight multiple tables in Google Sheets. I’ll explain that later.įurther, you can extend the range from B3:J10 to B3:Z100 or more. To highlight the second column we can follow a simple trick. This rule will only highlight the first matching column in each table in the range B3:J10. Here is the conditional format rule to highlight multiple tables in Google Sheets. If matches, highlight the corresponding whole table with light grey color (change the criteria as per your requirement).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |