Conditional Formating: highlight column A values based on "tag" from same row on column B

[Annie Liz]

The picture shows what I want to achieve:

Values are GREEN if positive & RED if negative, however I need some of those values to be BLUE based on same row tag from another column (like the "C" tag on Column A or the word "Type C" on Column B)

I can achieve the GREEN & RED coloring with just 2 entries on conditional formating rules for the whole column C, I just can't figure how to achieve a BLUE coloring rule if those values aren't unique to tagged items.

Only idea was create a rule for a single row & then copy/paste that row as needed, but doing so would create thousands of rule entries that would be impossible to modify later.

*btw the list would be thousands of rows long but finite if that helps.

Any help would be appreciated, thanks!

Version: Office 2010 HS

 

[mart37]

=OR(A1="c",[COLOR=#008000]IFERROR([COLOR=#0000FF]SEARCH("type c",B1)[/COLOR]>0,FALSE)[/COLOR])

 

[MARZIOTULLIO]

=$A3<>"" applies to =$A$3:$A$15 in first position in rule applied blu color

 

[mart37]

#2 : applies to $C$1:$C$15

 

[MARZIOTULLIO]

#3
applies to =$A$3:$A$15 is wrong

use applies to $C$3:$C$15

 

[Annie Liz]

=OR(A1="c",[COLOR=#008000]IFERROR([COLOR=#0000FF]SEARCH("type c",B1)[/COLOR]>0,FALSE)[/COLOR])

Thanks! this worked perfectly.