Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

You can enter =B10-A10 in C10 to get the difference between the new and old price there. You will probably need another column for testing the price increase: in D10 enter =(C10/A10)*100. Then select the used cells in the D column and select Format - Conditional formatting, set Cell value to Greater than, enter 30 in the field to the right, assign a style for the cells that meet the condition and modify the formatting details of that style to your needs, like set Font color to Red.

You can enter =B10-A10 in C10 to get the difference between the new and old price there. You will probably need another column for testing the price increase: in D10 enter =(C10/A10)*100. Then select the used cells in the D column and select Format - Conditional formatting, set Cell value to Greater than, Not between, enter 30 in the field fields to the right, assign a style for the cells that meet the condition and modify the formatting details of that style to your needs, like set Font color to Red.