The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » vba-excel-training - Cells

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

vba-excel-training - Cells

Resolved · Low Priority · Version Standard

ReplyWed 5 Dec 2007, 09:53Delegate Khuram said...

Cells

How do you change the colour and thickness of the selector cell.

For upcoming training course dates see: Pricing & availability

ReplyFri 7 Dec 2007, 13:27Trainer Katie said...

RE: Cells

Hi Khuram,

Thank you for your question.

To format border & colour of a cell:

1 - Select your cell(s);
2 - FORMAT menu > CELLS > BORDER tab
3 - Select a thickness & colour to add on border
4 - Choose which line(s) to apply this border;
5 - Switch to PATTERNS tab & choose a colour for the cell;
6 - press OK to view the result

Hope this helps.

Regards,

Katie

ReplySat 8 Dec 2007, 14:59Delegate Khuram said...

RE: Cells

Hi Katie,

Im wishing to change the colour of the cell selector (THE CELL THAT YOU CAN MOVE AROUND WITH THE ARROW KEYS), not just a cell.

ReplyWed 16 Jan 2008, 10:07Trainer Carlos said...

RE: Cells

Hi Khuram

The cell selector in Excel is always Bold Black.

I have looked around and haven't found anything that allows the user to change the colour

Regards

Carlos

ReplyWed 16 Jan 2008, 10:40Delegate Khuram said...

RE: Cells

Hi, Katie,

Thanks for your reply but I dont want to change the colour of a fixed cell. I want to change the colour of the selector cell, the cell which is controlled by the mouse or cursor keys. :)

ReplyWed 16 Jan 2008, 11:10 Edited on Wed 16 Jan 2008, 11:11Trainer Carlos said...

RE: Cells

Hi Khuram

You seem to have missed my reply.

The cell selector in Excel always shows as Bold Black.

I have looked around t6he web and a few expert books and haven't found anything that allows the user to change the colour of the Selector Cell.

Regards

Carlos

Excel articles

· Never Lose It In Translation With Excel
· Benefits of learning about Excel charts
· Let Excel look after the pennies, and the pounds will take care of themselves
· Why Excel Training (Sometimes) Doesn't Work and What You Can Do About It
· How To Create An Excel Formula Using Data From Several Worksheets

Excel tip:

The Easiest Way to See a Sum or Average in Excel 2010

Did you know the quickest and most simple way of working out the average or sum of a set of numbers?

Highlight numbers in cells or type some numbers in cells and then look at the status bar at the bottom of the window. Here you will see a display of the average of the numbers, as well as a count of the cells and the sum of these cells.

View all Excel hints and tips

How do i hide the zero's in a document