Cond. Format. - using 3 rules at once on a single cell

[xtreme07]

need help on making the cond. format. to use all three text features at once (bold, underline, italic) when all the 3 conditions match the columnA.

below you can find a simple demo of what i have and what i need achieved.
works for excel 2007 and above
http://download34.mediafire.com/7ksic77x88kg/unvbdp45g74mtkl/mrexcelXtreme07.xlsx
Edit: updated file
http://download1014.mediafire.com/m07987b229pg/blao34s9ja66ze4/mrexcelXtreme07.xlsx

 

[Andrew Poulsom]

Edit the rule and click Format. On the Font tab check Bold Italic under Font style and select Single in the Underline dropdown.

 

[xtreme07]

Edit the rule and click Format. On the Font tab check Bold Italic under Font style and select Single in the Underline dropdown.

i have 3 rules. each rule uses different formating so i can identify each rule and choose keywords based on that.
each rule is defined based on words matching for columnA.
each rules has it's own list. 3 list in total <=> 3 rules

since, each rule is for specific list, this makes the rules bump into one another and the output would then be: only one rule applied.

please take a look into the file from post1 to see the 3rules in action and the output that i need

 

[xtreme07]

i'd appreciate some input here

 

[Andrew Poulsom]

To match all three conditions use:

=MAX(INDEX(COUNTIF(A1,"*"&sections&"*"),0))*MAX(INDEX(COUNTIF(A1,"*"&categories&"*"),0))*MAX(INDEX(COUNTIF(A1,"*"&subjects&"*"),0))

Note that if you have bold for one condition and underline for another condition you won't get bold underline if both conditions are met.

 

[Andrew Poulsom]

In my previous post I should have said bold and italic not bold and underline.