PC Review


Reply
Thread Tools Rate Thread

Change Format of Active Cell

 
 
magmike
Guest
Posts: n/a
 
      14th Jul 2011
In Excel 2007, on WinXP SP3,

I would like to be able to change the format of the currently active
cell to make it more easily visible at a quick glance. Currently, the
active cell is just outlined in a thick black line. Is there a way to
change conditional formatting to change the fill color and/or the
outline color of the currently selected/active cell?


Thanks in advance,


magmike

PS: Sorry for cross posting - I accidentally posted this in
excel.programming but meant to post here.
 
Reply With Quote
 
 
 
 
Jim Cone
Guest
Posts: n/a
 
      14th Jul 2011
Maybe changing the gridline color could make a difference...
Excel Options | Advanced | Display options for this worksheet | Gridline color

Also, Chip Pearson has code and a free add-in that not all like at...
http://www.cpearson.com/excel/excelM...ightActiveCell
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
('Shade Data Rows' the way you want them)




"magmike" <(E-Mail Removed)>
wrote in message
news:70a479a1-e947-4438-a3dd-(E-Mail Removed)...
> In Excel 2007, on WinXP SP3,
>
> I would like to be able to change the format of the currently active
> cell to make it more easily visible at a quick glance. Currently, the
> active cell is just outlined in a thick black line. Is there a way to
> change conditional formatting to change the fill color and/or the
> outline color of the currently selected/active cell?
>
>
> Thanks in advance,
> magmike
>
> PS: Sorry for cross posting - I accidentally posted this in
> excel.programming but meant to post here.



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change Format of Active Cell magmike Microsoft Excel Programming 15 19th Jul 2011 07:13 AM
Format / Highlight the Active Cell mcastellano@gmail.com Microsoft Excel Programming 1 28th May 2006 03:26 AM
Changing an active cell format in VBA Packman Microsoft Excel Misc 4 6th Apr 2006 07:02 PM
Lock Cell Format - Allow copy and paste of data without format change Chris12InKC Microsoft Excel Worksheet Functions 1 11th Mar 2006 04:44 AM
How do I change the format of how my active cell in Excel is view. =?Utf-8?B?SmFtZXMgV2hhbGV5?= Microsoft Excel Misc 1 4th Oct 2004 10:42 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:36 PM.