Multi Colour Conditional Formatting on calculate

[MoonWeazel]

Morning All,

I have a spreadsheet which has lots of garish colours on it (not my design) and I would like it to update the colours on link update (the spreadsheet is linked to lots of other spreadsheets).

I have the multi-conditional formatting code working using the "Private Sub Worksheet_Change(ByVal Target As Range)" function.

This does work in the changing cell colour but only when the cell is entered and the enter key is pressed.

Is there any way to automatically change the colours when updating the links?

TIA,

MoonWeazel

[davesexcel]

How about

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub


or

Private Sub Worksheet_Activate()

End Sub

[MoonWeazel]

thanks for the response!

it does work but not when the links are updated on opening.

cheers!

lou

[Stuie]

you could mayb do this.

Write the code that changes the formats into a sub eg:

Sub colourChange()

End Sub

and then on the workbook open you could do this:

Private Sub Workbook_Open()

Call colourChange

End Sub

this will run the colour change macro each time the workbook is opened and then you can run the macro in the other ways with the same "Call colourChange" statment.