Forum Discussion
ze696
Feb 27, 2024Copper Contributor
help with conditional formatting
Hello, I need help with that : "Use conditional formatting to highlight, with different colors: the prices in column 'arrondi sup' less than or equal to 3 euros, between 3 (excluding) an...
HansVogelaar
Feb 27, 2024MVP
- Create a rule for 'greater than' and value 10
- Create a second rule for 'less than or equal to' and value 10
- Create a third rule for 'less than or equal to' and value 5
- Finally, create a fourth rule for 'less than or equal to' and value 3
If you create the rules in this order, the values should be highlighted correctly.