Hello everyone, I'm a helper. Today I share with you the excel same content whole line color change skills, dynamic conditional formatting, highlighting do not worry.
There's good news! In order to facilitate everyone to grasp the skills faster, look for shortcuts. Please click on the "Learn More" at the end of the article, find and follow me inside, there are a large number of various types of template materials free to download, I am waiting for you Oh ^^ < - very important !!!
メPlease look at the example picture, Excel table A column contains multiple identical data, how to select when the whole row is highlighted. メ
メWe frame the data column (without header) - conditional formatting - create a new rule. メ
メUsing a formula to determine the cells to be formatted - input function =$A 2 =CELL("contents"), click Format to select a color inside the fill. メ
メA column cell "Mouse", the same row of the whole row is discolored, highlighted. メ
メWe select other cells in column A, after selection, press F9 refresh key, automatically change the refresh fill effect. メ
メIf you want to use the automatic color change, click On Worksheet - Right click to find the code. メ
メ In the pop-up window, copy and paste the following code into it - you can ALT+F11 to see the effect. メ
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Calculate
End Sub
メ Click on any cell in column A, the whole row of the same content line will be automatically colored. メ
メThis save prompt did not start the macro. メ
メwe save as an Excel startup macro template, finish the file saving, simple and easy, everyone hurry up to learn. メ
How to download! The helper will regularly update various template materials every day to obtain them.
1. Please comment + like ^o^ in the comment area
2. Click Follow to pay attention to the headline number
3. Enter the headline page, the private message function in the upper right corner, the private message reply to the "form", and directly obtain various materials.