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

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

Use Format=Conditional Formatting

Assumes data is in columns A to D and Price DROPS i.e new price =old price -
Retro (Retro is NOT +/- to indicate increase/decrease). If Retro can indicate
a price increase as well as decrease, you need a different formula (which you
can work out from the one below!).

Highlight column C :

FormulaIs:

=AND($C1<"",($D1/$B1)=0.25)

and set "Pattern" to your required colour

HTH


"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

Thanks

Toppers

"Toppers" wrote:

Use Format=Conditional Formatting

Assumes data is in columns A to D and Price DROPS i.e new price =old price -
Retro (Retro is NOT +/- to indicate increase/decrease). If Retro can indicate
a price increase as well as decrease, you need a different formula (which you
can work out from the one below!).

Highlight column C :

FormulaIs:

=AND($C1<"",($D1/$B1)=0.25)

and set "Pattern" to your required colour

HTH


"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