How to Format All Comments Based on a Comment in Excel Office 365?
Tags: formatallcommentsine, kutoolsexceltutorial, kutools
Published: 2020-11-03 11:50:57

---
title: How to Format All Comments Based on a Comment in Excel Office 365?
published: true
date: 2020-11-03 11:44:08 UTC
tags: FormatAllCommentsinE,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/how-to-format-all-comments-based-on-a-comment-in-excel-office-365/
---

In this guide, we will explain how to **Format All Comments Based on a Comment in Excel Office 365** using **Kutools.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Format All Comments Based on a Comment:

To format all comments based on specific formatting comments in Excel, do as follows.

- First, you need to **activate the worksheet** that you want to format all the comments with the same formatting.
- Then, you need to make sure that there are comments on the active sheet.
- You need to format one comment as you desire. Refer to the below example image.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Example-8.png)<figcaption id="caption-attachment-16769">Example</figcaption>

- Now, on the **Kutools Tab, select** the **More** option, **choose** the **Format Comment** option from the drop-down list.

![Select the Format Comment option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Format-Comment-option.png)<figcaption id="caption-attachment-16770">Select the Format Comment option</figcaption>

- It will open the **Format Comment Dialog Box.**
- **Scope –** You need to **choose any one option** from this drop-down list.
- Then, **click** the **Specify the comment cell** option to select the cell that has a comment formatting.

![Format Comment Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Format-Comment-Dialog-Box.png)<figcaption id="caption-attachment-16771">Format Comment Dialog Box</figcaption>

- A new prompt box will pop-out to ask you the range. You need to **select the cell** and **click** the **OK** button.

![Select the cell](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-cell.png)<figcaption id="caption-attachment-16772">Select the cell</figcaption>

- Now, a dialog box will pop-out to tell you how many comments have been converted. Then, **hit** the **OK button** to close this dialog box.

![Click the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Click-the-OK-button-2.png)<figcaption id="caption-attachment-16773">Click the OK button</figcaption>

- As a result, you can see all the formatting of all other comments has been changed to the same formatting as the selected comment.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Result-3.png)<figcaption id="caption-attachment-16774">Result</figcaption>

## Closure:

In this guide, you can clearly understand the steps to **Format All Comments Based on a Comment in Excel Office 365** using **Kutools. ** Share your **suggestions/feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Ahead:

- [How to Create a Thermometer Chart in Excel 365? {using Kutools}](https://geekexcel.com/how-to-create-a-thermometer-chart-in-excel-365-using-kutools/)
- [Reverse Text String or Words Order in Excel Office 365!!](https://geekexcel.com/reverse-text-string-or-words-order-in-excel-office-365/)