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

iMac Pro review

Illustrator of witty, relatable Instagram comics Julia Bernhard touches on our humble moments

iMac Pro review

Quelle est la meilleure application de podcast pour Android (2018) ?