Formula Question

[Rob]

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

 

[Nav]

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.

 

[Toppers]

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]

Thanks

Toppers

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