I will be happy to help you with this. Would you like me to send you a sample file with the conditional formatting set up on it, or do you just need then the instructions
I think the instructions would be best as long as they are step by step. If I make one wrong click on this test there are no second chances. (Its a 60 question exam and this is the only one I cant figure out on my own.)
Ok will prepare the instructions in a moment. In the meantime here is a sample file with the conditional formatting which will help you understand the instructions
These are the data values:
No I think you are mistaken about the rim colors. Here are the available options
One moment let me finish the instructions....
Here you go
1- Select the cells that you want to apply conditional formatting on
2- Click the Home tab, then in the Styles group click the Conditional Formatting icon, and select New Rule
3- In the top window make sure that "Formal all cells based on their values" is selected
4- Now in the lower window, select "Icon Set" from the field 'Format Style'
5- In the field 'Icon Style" select the rimmed traffic lights
6- In the first 'When Value is' fields select these three value ">=" , "2000", "Number"
7- In the seond 'When Value is' fields select these three value ">=" , "1000", "Number"
8. Click Ok, click Apply, click OK
And here is the file with the specific values that you requested
Hope this helps. Let me know if you have any questions