Chris Norton
New Member
- Joined
- Sep 16, 2002
- Messages
- 11
Hi folks
Sorry to trouble you all - I would be grateful for a little help in that I want to create a query that allows me to highlight the following;
If Cell C6 is between 0 & 5, it displays the word "LOW" and the cell is coloured green background
If it is between 6 & 10, it displays the word "MEDIUM" and the cell is coloured amber background
If it is between 11 & 15 it displays the word "HIGH" and the cell is coloured red background
Would appreciate anyone's guidance or advice on this. Many thanks in advance.
Sorry to trouble you all - I would be grateful for a little help in that I want to create a query that allows me to highlight the following;
If Cell C6 is between 0 & 5, it displays the word "LOW" and the cell is coloured green background
If it is between 6 & 10, it displays the word "MEDIUM" and the cell is coloured amber background
If it is between 11 & 15 it displays the word "HIGH" and the cell is coloured red background
Would appreciate anyone's guidance or advice on this. Many thanks in advance.