Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

Kutools for Excel 20.00 HOT

300+ Powerful Features You Must Have in Excel

Kutools-for-Excel

Kutools for Excel is a powerful add-in that frees you from performing time-consuming operations in Excel, such as combine sheets quickly, merge cells without losing data, paste to only visible cells, count cells by color and so on. 300+ powerful features / functions for Excel 2019, 2016, 2013, 2010, 2007 or Office 365!

Read More Download Buy now

Office Tab 14.00HOT

Adding Tabbed Interface for Office

Office Tab

It enables tabbed browsing, editing, and managing of Microsoft Office applications. You can open multiple documents / files in a single tabbed window, such as using the browser IE 8/9/10, Firefox, and Google Chrome. It's compatible with Office 2019, 2016, 2013, 2010, 2007, 2003 or Office 365. Demo

Read More Download Buy now

Kutools for Outlook 11.00NEW

100+ Powerful Features for Outlook

Kutools-for-Outlook

Kutools for Outlook is a powerful add-in that frees you from time-consuming operations which majority of Outlook users has to perform daily! It can save your time from using Microsoft Outlook 2019, 2016, 2013, 2010 or Office 365!

Read More Download Buy now

Kutools for Word  9.00NEW

100+ Powerful Features for Word

Kutools-for-Word

Kutools for Word is a powerful add-in that frees you from time-consuming operations which majority of Word users have to perform daily! It can save your time from using Microsoft Word / Office 2019, 2016, 2013, 2010, 2007, 2003 or Office 365!

Read More Download Buy now

Classic Menu for Office

Bringing Back Your Familiar Menus

Restores the old look and menus of Office 2003 to Microsoft Office 2019, 2016, 2013, 2010, 2007 or Office 365. Don’t lose time in finding commands on the new Ribbon. Easy to deploy to all computers in enterprises and organizations.

Read More Download Buy now

Quickly format cells or rows when cell value change in Excel

For example, you want to change shading or add borders when cell value changes in a column, normally you can apply conditional formatting to settle this matter. But what if inserting page breaks or blank rows when a column value changes? Here, Kutools for Excel’s Distinguish differences (by key column) feature will solve all these problems easily with several clicks only.

Office Tab Enable Tabbed Editing and Browsing in Office, and Make Your Work Much Easier...
Kutools for Excel - The Best Office Productivity Tool Will Solve Most of Your Excel Problems
  • Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
  • More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words...
  • Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum...
  • Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns...
  • Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Create Mailing List and Send Emails by Cell's Value...
  • Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment...
  • More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in company; Full features 60-day free trial.

 Click Kutools > Format > Distinguish differences. See screenshot:

Distinguish Differences, insert page breaks, blank cells, or format cells/rows when cell value changes in the key column


 Insert page break when cell value changes in Excel

With the Distinguish Differences (by key column) feature of Kutools for Excel, you can easily insert multiple page breaks when the cell value changes in the specified key column. Please do as follows:

1. Click Kutools > Format > Distinguish differences to open the Distinguish differences by key column dialog box.

2. In the opening dialog box, please do as follows:
(1) In the Range box, please specify the selection that you will insert page breaks into.
(2) In the Key column box, please select the column whose cell values you will insert page breaks based on;
(3) In the Options section, please check the Page Break option.
Distinguish difference dialog

Tip: If you need to distinguish differences with matching case exactly, please check the Case sensitive option.

3. Click the Ok button.

Now you will see page breaks are inserted when cell value in the specified column changes. See screenshot:
Insert page breaks when cell value changes in the key column


 Insert blank row when cell value changes in Excel

You can also insert blank rows based on cell value changes in the specified key column with the Distinguish differences (by key column) feature. Please do as follows:

1. Click Kutools > Format > Distinguish differences to open the Distinguish differences by key column dialog box.

2. In the opening dialog box, please do as follows:
(1) In the Range box, please specify the selection that you will insert blank rows into.
(2) In the Key column box, please select the column whose cell values you will insert blank rows based on;
(3) In the Options section, please check the Blank row option, and specify the number of blank rows as you need in below box. See screenshot:
Insert blank rows when cell value changes

Tip: If you need to distinguish differences with matching case exactly, please check the Case sensitive option.

3. Click the Ok button.

Now you will see blank rows are inserted when the cell value in the specified key column changes.
Insert blnak rows when cell value changes


 Add bottom border when cell value changes in Excel

With the Distinguish differences (by key column) feature, you can also add bottom border to cells, rows in the specified selection, or entire rows when cell value changes in the specified key column. Please do as follows:

1. Click Kutools > Format > Distinguish differences to open the Distinguish differences by key column dialog box.

2. In the opening dialog box, please do as follows:
(1) In the Range box, please specify the selection that you will add bottom borders into.
(2) In the Key column box, please select the column whose cell values you will add bottom borders based on;
(3) In the Options section, please check the Bottom Border option, specify the border style, and choose the border color.
(4) In the Scope section, choose the format scope as you need: A. if you choose Key column, it will add bottom border to cells in the specified key column when the cell values in the specified column change; B. if choose Selection, it will add bottom borders to rows in the specified selection; C. if choose Entire row, it will add bottom borders to entire rows. See screenshot:
Add bottom border when cell value changes

Tips:
(1) If you need to distinguish differences with matching case exactly, please check the Case sensitive option.
(2) If you need to clear existing borders, please check the Clear existing borders option.

3. Click the Ok button.
Now bottom borders are added when the cell values in the specified key column change. See screenshot:
Add bottom border when cell value changes in the key column


 Highlight cell or row when cell value changes in Excel

This Distinguish differences (by key column) feature also supports to highlight cells, rows in the specified selections, or entire rows when the cell value changes in the specified key column. Please do as follows:

1. Click Kutools > Format > Distinguish differences to open the Distinguish differences by key column dialog box.

2. In the opening dialog box, please do as follows:
(1) In the Range box, please specify the selection that you will highlight differences.
(2) In the Key column box, please select the column whose cell values you will highlight cells or rows based on;
(3) In the Options section, please check the Fill Color option, and specify the highlight color.
(4) In the Scope section, choose the format scope as you need: A. if you choose Key column, it will highlight cells in the specified key column when the cell values in the specified column change; B. if choose Selection, it will highlight rows in the specified selection; C. if choose Entire row, it will highlight entire rows. See screenshot:
Fill cell or row when cell value changes

Tips:
(1) If you need to distinguish differences with matching case exactly, please check the Case sensitive option.
(2) If you need to clear existing fill color, please check the Clear existing fill color option.

3. Click the Ok button.

Now you will see the cells or rows are highlighted when the cell value in the specified key column changes.
Fill cell or row when cell value changes


 Notes

This feature supports undo.


 Demo: format cells or rows when cell value change in Excel

Kutools for Excel: with more than 300 handy features, free to try with no limitation in 60 days. Download and free trial Now!

Productivity Tools Recommended
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2019, 2016, 2013, 2010, 2007 and Office 365.
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013, 2016, 2019 and 365, as if it were Office 2000 and 2003.

Kutools for Excel

The functionality described above is just one of 300 powerful functions of Kutools for Excel.

Designed for Excel(Office) 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 60 days.

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.

Feature Tutorials