Is there a way to create a table and use that table to format cells? - Custom Formatting

[1vanY]

So we sell bare roots that have different pricing when you buy bulk.
Generally, If you buy 1-2 plants, they're $4 each. If you buy 3-11, they're $3 each. 12-35 = $1.75/ea. 36-99 = $1.25.
When we export an Inventory report out of our Order Processing software into Excel, Excel thinks that the price breaks (4-3) is actually a date of 4/3.
I'm aware that you can create custom formats for cells, but we have so many price breaks that it seems to be too large of a string to fit all the price breaks.

Is there a way to create a table and use that as a reference to format cells?

"Price Matrix Legend": Shows example of how the report Should look
"Custom Format":
* Original Report Worksheet: Shows how the original report exports into Excel from our order processing software
* PRICE MATRIX Worksheet: Shows the custom formatting that we need to use
* PRICE MATRIX pic: Shows the custom formatting I'd like to choose, so Excel knows how to interpret values

If this exceeds Excel's limitations, then maybe a mass 'Find and Replace' method would work better...

My apologies if this sounds confusing or left anything out!

Thank you in advance!

Also posted here Is there a way to create a table and use that table to format cells

 

[Fluff]

Not quite sure what you'r hoping to get, but would this work
=IF(C2>43000,TEXT(C2,"d - m"),C2)

 

[1vanY]

Not quite sure what you'r hoping to get, but would this work
=IF(C2>43000,TEXT(C2,"d - m"),C2)

Perfect!! That works, much appreciated!

 

[Fluff]

You're welcome & thanks for the feedback.