To set conditional formatting
1. Select the required cells
2. Select “Conditional Formatting” from the menu bar
3. Enter the rule to be applied. In this case, any figure greater than £100 to be highlighted in a dark red font with a light red fill.
To set conditional formatting
1. Select the required cells
2. Select “Conditional Formatting” from the menu bar
3. Enter the rule to be applied. In this case, any figure greater than £100 to be highlighted in a dark red font with a light red fill.