• 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
24
270 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
  • AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 2 Years AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 2 Years
    Rated 5.00 out of 5
    $47.00
  • Avast Premium Security 2021 10 Devices 1 Year Global Avast Premium Security 2021 10 Devices 1 Year Global
    Rated 5.00 out of 5
    $28.00
  • Avast Ultimate Suite 2021 3 Years 10 Devices Global Avast Ultimate Suite 2021 3 Years 10 Devices Global
    Rated 5.00 out of 5
    $90.00
  • Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $22.00
  • Kaspersky Internet Security 2021 1 year 1 device key Global Kaspersky Internet Security 2021 1 year 1 device key Global
    Rated 5.00 out of 5
    $24.00
Products
  • Avast Ultimate Suite 2021 1 Year 10 Devices Global Avast Ultimate Suite 2021 1 Year 10 Devices Global
    Rated 5.00 out of 5
    $54.00
  • Windows 10 Education Key Global Windows 10 Education Key Global
    Rated 4.84 out of 5
    $9.00
  • Microsoft Office Home And Business 2019 CD Key for MAC Global Microsoft Office Home And Business 2019 CD Key for MAC Global
    Rated 4.95 out of 5
    $30.00
  • Avast Premium Security 2021 10 Devices 2 Years Global Avast Premium Security 2021 10 Devices 2 Years Global
    Rated 5.00 out of 5
    $41.00
  • Buy Windows 11 Home CD Key Global Buy Windows 11 Home CD Key Global
    Rated 4.73 out of 5
    $6.00
  • Kaspersky Premium - 1 Device 1 Year - GLOBAL Kaspersky Premium - 1 Device 1 Year - GLOBAL $37.00
  • Microsoft Visual Studio Enterprise 2022 For 1 PC Microsoft Visual Studio Enterprise 2022 For 1 PC $19.00
  • Avast Ultimate Suite 2021 2 Years 10 Devices Global Avast Ultimate Suite 2021 2 Years 10 Devices Global
    Rated 5.00 out of 5
    $77.00
  • Windows 10 Home OEM Key Global Windows 10 Home OEM Key Global
    Rated 4.80 out of 5
    $6.00
  • Microsoft Visio Standard 2021 Key 1PC Microsoft Visio Standard 2021 Key 1PC $13.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.