Is there a way in Excel to have two different formulas and if the number in
the cell color in black it uses one formula and if the color of the number in
the cell is red it uses a different formula?

Example:
40 hours of payroll multiplies the hourly wage by the 40 hours if
43 hours in red color font the formula would say if 40 then multiply the
40 hours by the regular hourly wage and the 3 by a differently wage, but if
the font color was still black it would multiply all 43 hours by the regular
wage?