I need to override the Honolulu county rate in Hawaii
To do this you will need to make a custom rule:
Create a rule at the county level for Hawaii
Choose rate override
Name and make your rule have the rate you would like it to have.
Going forward transactions that fall in this county will have this rate applied to them.