Question about conditonal formatting!

[24kblondi]

Hi! New here, looks like a great place to get help!

Is there a way to get around the 3 limit rule on conditional formatting?

Id like rows highlighted differently if column A has certain codes in it...
I currently need one color if its one of 3 codes
another color if it has one of 2 diff codes
and last color if it has 2 more diff codes

IE: If cell value is equal to CCV highlighted blue
and i have 7 diff codes that will use 3 different colors...

Does that make sense?

Im so frustrated!! haha ....thank you for any help!!

 

[VoG]

See if this helps http://www.vbaexpress.com/kb/getarticle.php?kb_id=90

 

[24kblondi]

WOW, that is so over my head! Thank you though...
Ill read through it and try to figure it out!

Thanks again

 

[VoG]

Having reread your question I don't think you will need code. If you use the Formula Is option you could use a formula like

=OR(A1="CCV",A1="BBC",A1="XYZ")

for one of your conditions.

 

[24kblondi]

YES!! Thats it....thank you so much!!!

 

[Marcelo Branco]

Maybe another possible solution is use blue as default (CCV)
Format cells
Fill ---> blue

Then in CF create 3 conditions like (assuming A1 as the target-cell)
=OR(A1="code1",A1="code2",A1="code3") ---> Fill pick color1

=OR(A1="code4", A1="code5") ---> Fill pick color2

=OR(A1="code6",A1="code7") ---> Fill pick color3

M.

 

[24kblondi]

Thank you too!