17. Click on the Setup section to open the settings available. In this example we will be defining alerts using the icons. You can also use the Cell or Text options if you just wish to display a block of colour rather than an image. 18. Set the Style to Icon and select the Ticks option as the Icon Set. 19. Define the Type as Value. This will mean that the value in the cell is compared to the alert values to check the rule, rather than another field or function. 20. Click on the Alerts section to open the alert rules list. This is where you will define the conditions. 21. Create three alerts: - Red Less than 12000000
- Orange Between 12000000 and 15000000
- Green Greater than 15000000
|