Hi Rob

Use Format - Conditional Format,
Cell Value is greater than 2.5 (or % depending on format) and add another
condition to less than 2.5, and set the format you would like to appear.

Hope it helps.

"Rob" wrote:

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