Applying bold to conditional formating new rule
To apply bold formatting to a conditional formatting rule in Google Sheets, you can follow these steps:
- Select the range of cells you want to apply the formatting to.
- Go to the "Format" tab in the top menu.
- Click on "Conditional formatting".
- Click on the "New rule" button.
- Select the "Custom formula is" option.
- In the formula bar, enter the formula you want to use to determine which cells to format. For example, if you want to format cells that are greater than 10, you would enter
=A1>10
. - Click on the "Format" button.
- In the "Format" dialog box, select the "Font" tab.
- Check the box next to "Bold" to apply bold formatting to the cells that meet the condition.
- Click "OK" to apply the formatting.
Here's an example of what the formatting rule would look like:
- Formula:
=A1>10
- Format: Bold
This will apply bold formatting to all cells in the selected range that have a value greater than 10.
You can also use the "Format" button to apply other formatting options, such as changing the font color or adding a border.