• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

Automatically Color Rows and Columns Based on Mouse Pointer

0 Comments

Automatically Color Rows and Columns Based on Mouse Pointer. With a large spreadsheet containing many rows and columns, it can be difficult to keep track of which row and column you are currently selecting. Today, Buffcom will guide you on how to automatically color cells based on the mouse pointer, which helps prevent data entry or verification errors.

Automatically Color – Coloring Rows

First, select the range of data and click on Home, then select Conditional Formatting -> New Rule.

Automatically Color Rows and Columns Based on Mouse Pointer

Automatically Color Rows and Columns Based on Mouse Pointer

In the new window, select “Use a formula to determine which cells to format”, then enter the formula =Row()=Cell(“Row”) in the “Format values where this formula is true” box. Select the desired fill color, then click OK.

Automatically Color Rows and Columns Based on Mouse Pointer

Automatically Color Rows and Columns Based on Mouse Pointer

Now, the color of the row has been applied, but it does not automatically follow the mouse pointer when you click on other rows. You can press F9 to manually refresh, but to automatically follow the mouse pointer, continue with the following steps.

Right-click on the sheet, select “View code”, and then copy and paste the following code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Application.ScreenUpdating = True

End Sub

Automatically Color Rows and Columns Based on Mouse Pointer

Automatically Color Rows and Columns Based on Mouse Pointer

With this code, the row where the mouse pointer is located will automatically change color.

Coloring Columns

To color columns instead of rows, follow the same steps as above but replace the formula with =Column()=Cell(“col”).

Automatically Color Rows and Columns Based on Mouse Pointer

Automatically Color Rows and Columns Based on Mouse Pointer

Coloring Cells

Finally, if you want to color individual cells based on the mouse pointer, use the formula =and(Row()=Cell(“Row”),Column()=Cell(“col”)) in the “Format values where this formula is true” box.

Automatically Color Rows and Columns Based on Mouse Pointer

Automatically Color Rows and Columns Based on Mouse Pointer

In this way, you can easily manage and keep track of the selected cell, row, and column by the visual color changes.

Thank you for reading Buffcom‘s article. Wishing you success!

Rate this post
31
275 Views
Guide on how to split Excel Sheets into separate Excel filesPrevGuide on how to split Excel Sheets into separate Excel filesMarch 21, 2023
3 ways to calculate the sum by range using the SUM function in ExcelMarch 21, 20233 ways to calculate the sum by range using the SUM function in ExcelNext

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • Kaspersky Small Office Security 15 PCs + 15 Mobiles + 2 Servers 1 Year Kaspersky Small Office Security 15 PCs + 15 Mobiles + 2 Servers 1 Year
    Rated 5.00 out of 5
    $201.00
  • Buy Windows 11 Professional MS Products CD Key Buy Windows 11 Professional MS Products CD Key
    Rated 5.00 out of 5
    $6.00
  • AVG Internet Security 2021 1 Device 1 Year Global AVG Internet Security 2021 1 Device 1 Year Global
    Rated 5.00 out of 5
    $11.00
  • Buy Office 2021 Professional Plus Key Global For 5 PC Buy Office 2021 Professional Plus Key Global For 5 PC
    Rated 5.00 out of 5
    $68.00
  • Avast SecureLine VPN 2021 2 Years 5 Devices Global Avast SecureLine VPN 2021 2 Years 5 Devices Global
    Rated 5.00 out of 5
    $47.00
Products
  • Microsoft Visio Professional 2010 Key 1PC Microsoft Visio Professional 2010 Key 1PC $9.00
  • Windows Server 2012 Remote Desktop Services 50 USER Connections Key Global Windows Server 2012 Remote Desktop Services 50 USER Connections Key Global
    Rated 4.69 out of 5
    $25.00
  • Windows 11 Home Key Global 2021 Windows 11 Home Key Global 2021
    Rated 5.00 out of 5
    $6.00
  • Windows Server 2025 Datacenter Windows Server 2025 Datacenter $30.00
  • Microsoft Visual Studio 2022 Professional Key Microsoft Visual Studio 2022 Professional Key $19.00
  • Windows 10 Enterprise LTSC 2019 Key Global Windows 10 Enterprise LTSC 2019 Key Global
    Rated 4.83 out of 5
    $9.00
  • Buy Office 2021 Professional Plus Key Global Bind To Your Microsoft Account Buy Office 2021 Professional Plus Key Global Bind To Your Microsoft Account
    Rated 4.71 out of 5
    $99.00
  • Kaspersky Internet Security 2021 1 year 5 devices key Global Kaspersky Internet Security 2021 1 year 5 devices key Global
    Rated 5.00 out of 5
    $45.00
  • AVG Internet Security 2021 1 Device 1 Year Global AVG Internet Security 2021 1 Device 1 Year Global
    Rated 5.00 out of 5
    $11.00
  • Office 2024 Home And Business For Mac/Pc Bind Office 2024 Home And Business For Mac/Pc Bind $99.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.