If cell A1 =02567-45, then color row light blue,if cell A2 is 2568-46, then color light brown
If cell A1 =02567-45, then color row light blue,if cell A2 is 2568-46, then color light brown
Conditional formatting is what you need. Here are some very helpful resources:
Basically, just select the cells to color and go to the Home tab and then Conditional Formatting and then Highlight Cells Rules and choose an option; this works for simple formulas.
Apply Conditional Formatting to Multiple Cells with a Single Formula