Positive Changes

This example shows you which rows have made a positive change.
Select the cells you want to apply the conditional formatting to, in this case "B2:C12".

alt text

Enter Conditions

Press (Format > Conditional Formatting) to display the Conditional Formatting dialog box.
Select the "Formula is" in the first drop-down list and enter the formula "=$C3>$B3".
You can either type the cell references or you can use your mouse to select the cell ranges.
When you want to refer to the active cell you need to refer to the first cell in the highlighted range.

alt text

Press OK to apply the conditional formatting.

alt text

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited TopPrevNext