Excel Highlights, how to change?

  SonnyB 20:01 08 Jun 2004

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 2004

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

  Lionheart ? 20:37 08 Jun 2004

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 2004

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 2004

Have you done this before?

The only way I know is a macro using Worksheet_Change.

  SonnyB 20:57 08 Jun 2004

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

  THE TERMINATOR 21:06 08 Jun 2004

what os?

  SonnyB 21:10 08 Jun 2004

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 2004

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 2004

I will try it, thanks,

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

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Best of the Grad Shows 2017: University of the West of England (UWE)

Best value Mac: Which is the best £1249 Mac to buy

Les meilleures GoPro 2017