Making Cell Contents Bold in Google Sheets Based on Formula Lookup from Another Sheet

Making Cell Contents Bold in Google Sheets: Based Formula Lookup from Another Sheet

In this article, we will explore how to make cell contents bold in Google Sheets based on a formula lookup from another sheet. This technique can be particularly useful when creating a fantasy football schedule or any other spreadsheet that requires special formatting based on specific conditions.

Introduction

Google Sheets is a powerful and popular spreadsheet application that is used by individuals and organizations around the world. One of the many benefits of using Google Sheets is its ability to perform complex calculations and formulas, making it an ideal tool for data analysis and visualization. In this article, we will focus on one specific use case: making cell contents bold based on a formula lookup from another sheet.

The Basics: Conditional Formatting

Before we dive into the specific formula for making cell contents bold based on a lookup from another sheet, it's important to understand the basics of conditional formatting in Google Sheets. Conditional formatting is a feature that allows you to automatically apply formatting (such as bold, italic, or a specific color) to cells based on a set of conditions. For example, you might want to make all cells containing negative numbers bold, or all cells containing specific text a certain color.

To access conditional formatting in Google Sheets, simply select the range of cells you want to format, then click on the "Format" menu and choose "Conditional formatting." This will open a panel on the right side of the screen, where you can set the conditions for your formatting.

The Formula: LOOKUP, IF, and FORMAT

Now that we understand the basics of conditional formatting, let's move on to the specific formula for making cell contents bold based on a lookup from another sheet. The formula consists of three main parts: LOOKUP, IF, and FORMAT.

=IF(LOOKUP(A2, 'Sheet2'!A:A, 'Sheet2'!B:B) = "vs", FORMAT(A2, "bold"))

In this formula, the LOOKUP function searches for the value in cell A2 on 'Sheet2', and returns the corresponding value from column B. The IF function then checks whether the returned value equals the string "vs". If it does, the FORMAT function is used to make the contents of cell A2 bold.

To use this formula, simply replace 'Sheet2' with the name of the sheet you want to lookup from, and replace "vs" with the specific value you want to search for. For example, if you wanted to search for the value "home" instead, you would use the following formula:

=IF(LOOKUP(A2, 'Sheet2'!A:A, 'Sheet2'!B:B) = "home", FORMAT(A2, "bold"))

Applying the Formula: Conditional Formatting

Now that we have the formula, we need to apply it to our spreadsheet using conditional formatting. Here's how:

1. Select the range of cells you want to format.
2. Click on the "Format" menu and choose "Conditional formatting."
3. Set the "Format cells if" condition to "Custom formula is."
4. Enter the formula we discussed above in the "Value or formula" field. Be sure to replace 'Sheet2' and "vs" with the appropriate sheet name and search value, respectively.
5. Click "Done" to apply the formatting.

In this article, we explored how to make cell contents bold in Google Sheets based on a formula lookup from another sheet. By using the LOOKUP, IF, and FORMAT functions, we were able to create a formula that automatically applies bold formatting based on a specific condition. This technique can be useful for a variety of use cases, including creating a fantasy football schedule or any other spreadsheet that requires special formatting based on specific conditions. With just a few simple steps, you can apply this formula to your own Google Sheets spreadsheet and take your data analysis and visualization to the next level.

References

• Google Sheets Conditional Formatting
• Google Sheets LOOKUP function
• Google Sheets IF function
• Google Sheets FORMAT function