I hate macros

[LisaContractorUmbrella]

Hey guys sorry to do this to you Friday pm but HELP!!!!!!! Recorded a macro which has ground to a halt and the debug says the problem is here:

Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
With Selection.FormatConditions(1).Font
.ThemeColor = xlThemeColorDark1
.TintAndShade = 0
End With

Was a simple conditional format to say that if the column contained a certain text change the font to white.

As always any ideas gratefully received


Don't worry - sussed it - have a good weekend all

 

[thunderlizard]

good to hear it. I did see that on Friday but though...can't be bothered.

Ting is, people who don't know Excel VBA wouldn't be able to help, but people who do know Excel VBA would want to start from scratch and needs lots of context information.

 

[LisaContractorUmbrella]

good to hear it. I did see that on Friday but though...can't be bothered.

Ting is, people who don't know Excel VBA wouldn't be able to help, but people who do know Excel VBA would want to start from scratch and needs lots of context information.

Thanks Mr Lizard - does seem that people in the know are quite um well passionate about VBA - saving your Lizardship's pardon of course

 

[MrRobin]

I have to ask though.... why couldn't you use the conditional formatting feature in Excel, rather than using VBA?

R.

 

[LisaContractorUmbrella]

I have to ask though.... why couldn't you use the conditional formatting feature in Excel, rather than using VBA?

R.

The conditional formatting was just a tiny part of a big macro