?
Solved

Adding Colour to the current cell

Posted on 2006-05-19
3
Medium Priority
?
235 Views
Last Modified: 2010-04-08
I've made a very "busy" spreadsheet in which data is entered. Is there a way to add colour to the current cell so when the mouse clicks on it, the cell changes colour - when the data is entered, the cell will revert back to normal?
0
Comment
Question by:BrentArmstrong
1 Comment
 
LVL 18

Accepted Solution

by:
p912s earned 200 total points
ID: 16725863
How 'bout highlight the current row/colmn as the cursor moves around the sheet. I use the code from the link below in several of my spreadsheets.

http://www.mrexcel.com/hof001.php
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The core idea of this article is to make you acquainted with the best way in which you can export Exchange mailbox to PST format.
With so many activities to perform, Exchange administrators are always busy in organizations. If everything, including Exchange Servers, Outlook clients, and Office 365 accounts work without any issues, they can sit and relax. But unfortunately, it…
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question