Conditional formatting Macro

[Stėophan]

Hi guys

I have a spreadsheet with the following code:

Please Login or Register  to view this content.

How can I add if the cell value is any other text that that specified it goes another colour?

And how do I add code to change the colour of the cell borders?

Any advice would be appreciated!

[mikerickson]

PLease read forum rules. Could must be wrapped

Doesn't your Case Else change the unlisted situations colours?
The macro recorder will show you the syntax for changing border colours.

[Stėophan]

Sorry for not wrapping the code - I'm new to this game!

The background of my workbook is grey, the cell range in question is populated after performing a If/Vlookup query. If after the query a value is returned and the value is NOT one of those in the code e.g. "Bakerloo Line", "Central Line" etc I want the cells to turn white.

[mikerickson]

If you want white

Please Login or Register  to view this content.

If you want "no fill"

Please Login or Register  to view this content.

[Stėophan]

I need an additional argument which turns the cells white when text [this can be any text whatsover] OTHER than that in the code populates the cells. My Case Else line leaves the cells grey when no text appears.

Does that make sense?

[mikerickson]

The Case <> vbNullString does what you want. It must be after all of the other options have been checked, but before Case Else.

Please Login or Register  to view this content.

[Stėophan]

That's great that's just what I need.

All I have to do now is figure out how to change the border colours.

Thanks for your help!