Formatting or Conditional Formula ??

[harryhaase]

Hi,


I need an formula or a conditional setting that shows no value when the previous value is the same. I tried doing this with an if statement, but it kept alternating between no value and a new value (since the formula was the same). I then tried to do it with nested if statements, but that didnt work either.

Basically, I am subtracting shipments from an original stock to show the month in which we are out. So, maybe there is a better way to do this.


Thanks,

 

[Luke M]

Assuming you have a list of dates/time and the respective amount of stock, CF formula would be:

=A2=A1

Format white font