Hello. I have the following line items in column A. I would like to create a conditional formatting that does the following. Based on value in A, color rows a certain color. If column A value starts with mb (NOT case sensitive) or has only six numbers at the beginning (for example, 601800 as apposed to 601800 601800 etc) I want to color it one color, and everything else (except for blanks) should be colored another color. Please help.


601190 601190 5007 ACCRUED PTO
601150 601150 5033 WAGES OVERTIME
601800 601800 5043 SEVERANCE

mb - other salary expense

602000 602100 5021 401K MATCH

mb - deferred compensation

601001 601200 5042 COMMISSIONS
601001 601300 5046 OTHER COMP - WELLNESS REWARDS
601001 601300 5049 OTHER COMPENSATION
601001 601200 5041 INCENTIVE COMPENSATION

621100 occupancy expenses