Excel Highlights, how to change?

  SonnyB 20:01 08 Jun 04

I am sure this can be done but I can't remember how you go about changing the colour of highlighted areas in an Excel 97 spreadsheet from black to something else.
I thought it was from desktop properties, then to appearance and advanced. By highligted I mean when you drag across a range of cells.
Anyone have an idea?

  THE TERMINATOR 20:32 08 Jun 04

Try changing the colour of the inactive window via display properties, this may help TT

  Lionheart ? 20:37 08 Jun 04

In Excel top right corner click arrow next to the little bucket, you can then change cell colour, aftre highlighting your cells

  SonnyB 20:43 08 Jun 04

Thanks both, but Terminator I have tried the inactive window in properties and I cannot find the command that will change the colour, do you know which it is?
Lionheart, I do not just want to re-formant the cells, which is I think what you are suggesting.

  VoG II 20:51 08 Jun 04

Have you done this before?

The only way I know is a macro using Worksheet_Change.

  SonnyB 20:57 08 Jun 04

yes I am pretty sure it can be done from display properties, but how?

  THE TERMINATOR 21:06 08 Jun 04

what os?

  SonnyB 21:10 08 Jun 04

the os is ms windows xp, and the application is ms office 97.
Thanks for asking terminator, any ideas?

  VoG II 22:11 08 Jun 04

Right click the sheet tab, View Code. Pasre in the following:

Private Sub Worksheet_Activate()

Set LastCell = ActiveCell


End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)

With Selection.Interior

.ColorIndex = 8

.Pattern = xlUp

.PatternColorIndex = xlAutomatic

End With

With LastCell.Interior

.ColorIndex = 0

End With

Set LastCell = Selection

End Sub

Coutesy of daba, with some help from me.

  SonnyB 22:14 08 Jun 04

I will try it, thanks,

This thread is now locked and can not be replied to.

What is Amazon Go and will it come to the UK? The store without checkouts or queues

1995-2015: How technology has changed the world in 20 years

Hands-on with the Star Wars fighting drones you can fly yourself

15 macOS Sierra tips | How to use macOS Sierra: Secret tricks and best new features in Apple's new…