Formula Question
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
|