markkevin29
New Member
- Joined
- Feb 3, 2022
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Need help to set the RAG format of the cell
Conditions as follow: 0 = green, > 0 is yellow, > 0 for last 3 months = red
Cant seem to apply formula using icons
Conditions as follow: 0 = green, > 0 is yellow, > 0 for last 3 months = red
Sample 1 | Sample 2 | Sample 3 | Sample 4 | Sample 5 | Sample 6 | |
Current Month | 1 | 0 | 1 | 1 | 0 | 0 |
Month-1 | 0 | 1 | 1 | 1 | 0 | 0 |
Month-2 | 0 | 1 | 1 | 0 | 0 | 1 |
RAG | Amber | Green | Red | Amber | Green | Green |
Cant seem to apply formula using icons
