Conditional Formatting using VBA

[TwistedFaith]

Hello I'm trying to find a way to Highlight cells and/or rows if a cell contains a specific text but also only highlight the rows if another cell on that same row is less than or equal to a certain number. And maybe highlight a different color depending on said number all while using VBA. I tried everything I could think off using conditional formatting and no luck with that.

anyways in the attached file If Column C contains the word outsider I want that row highlighted one color; If in that same row that contains "outsider" in Column C, Column
E contains the number 6 or lower I want that row a completely different color; and again if Column E is between 7-12 I want a completely different color; And again if Column E is between 13-18 again different color.

[mjr veverka]

Try:

Please Login or Register  to view this content.

[TwistedFaith]

ok Thanks that worked. Now just in case it I want to add word that that list (ie outsider and something else (lets say ooze)) with the same criteria how would I do that.

[TwistedFaith]

I'm also gonna have another project going on where I need to add numbers to cells that contain certain words and subtract numbers from everywhere else. The numbers will be connected to a Named range/data/formula. so I'll post about that later when I need to.

[mjr veverka]

Why are you increasing your demand as you receive a response ?
Why don't you write what you want right away ?

[TwistedFaith]

sorry but yeah the second project is actually from This Post that I posted a while ago and got an answer for using conditional formatting that worked but not all that well for me.

[TwistedFaith]

Sorry It took me a while to figure out what was wrong with the link I was trying to link to in the above post. It's now fixed and linked to the proper post.

Please help me with this. Either here or on the linked thread above Preferably on the linked post as that has the workbook I need the VBA Code on. I know it was technically solved with formula/s but if I change anything it messes up but with VBA it would be fixed the way I need it.

Thanks in advance for any and all help given (if any help is given).