Looking to highlight product price if it should drop in value by 25% and need
help with the formula to do this.

Have these columns for a worksheet

Product Code Price NewPrice Retro
123456 10.00 9.00 1.00

If i enter the retro as 2.50 + i would like the new price to be highlighted
in Red or whatever other colour i chose.

Can anyone help