Change pattern based on cell value (Multiple conditions)

As per attached excel file, I want 4 pattern condition to run automatically when text inside cell C6 changed.

http://www.excelforum.com/attachment...1&d=1462856509

Code 1 have so far

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Why code it when it can be done using Conditional Formatting?

Hi cytop,

already open a thread regarding conditional formatting, nobody want to help..

Not saying it's exactly what you want, but Conditional Formatting applied for the various frequencies. I've used solid colours only because the pattern you had causes moiré effects on my screen. You can edit the fill/patterns to suit yourself.

Thank you cytop, now im understand why my formula didnt work. Need to use "," to apply to multiple area. Many thanks!

Please Login or Register  to view this content.

Hi again cytop, after changing the pattern, it seem doesnt work. anyhelp?

what im missing here?

http://www.excelforum.com/attachment...1&d=1462869724

OK, moiré effects

Do you still have a problem? Like I said, I only used a solid color as I didn't fancy a headache when I scroll the worksheet...

Solved. Many Thanks!

That's good. Enjoy.