Question

Please show all the steps. I am using office 360. Thank you!

A B C D E F G H 1 1 2 Inventory Turnover 3 5 4 5 6 7 8 9 10 11 12 13 14 15 16 Item AB101 XY200 CG231 HA882 ZZ750 LLOO2 PY552 JJ120 JA221 RJ061 Turnover 12.5 20.1 8.2 1.1 2.1 3.6 10.9 18.2 11.7 5.2 Required: Apply the 5 Quarters Icon Sets formatting to the Turnover column. 17

Answer 1

A Steps to apply the 5 Quarters Icon sets formatting to the Twenover column Sep 1 Select the Turnouer columm from cell D5: 014 Step 2: After wecting all 05:014, Go to "Home". In Home 7 Go to Conditional Formatting. Step 3 å mi conditional Formatting", click on + Icon sets". Step 4. ナ m Icon sets at the second last now or bottom side, you will find s wides presented as follows QOQO the above of those 5 circles Sleps: once you click on the 5 willes, you will notice that 5 Quarter Icon Sets formatting has been applied Notes in following above steps, if you mistakenly applied 3 some other rule, than you can always click on "clear rules" which you will find in "conditional formatting To demonebrate the above steps, I have also attained picture of microsoft Excel Sheet

B. Steps to format the score column with green red dvientional arrous for above to, so-69 and below so respectively yellow and scores Step 1 Select the score columns from all (3:14 Step 2 . After weding acco: (14, Go to "Home" » conditional Formatting and then click on Sup 3: m " Conditional Formatting", click on "Icon Setene 71 Step 4 Once you click Icon Sets", you will notice an addition small window on the right side.. m this window the extreme bottom you will find more Rulescu Click more Rules..." + )) 1) Steps After dicking on "more Rules..." ", "New formatting Rulle" window will open top plese select " Format all cells based on their values" in "Select a Rule Type". on the Now Step 6: move to "Edit the Rule Description" ( below " Select Select a Rule Type ") a) In "Format Style, Selest "Icon Sete' prom dropdown. b) In "Icon Style", select the first result from dropdown which is 3. colored directional arould

Step 7 : Now comes the very important step. we have to set nule to format the score ashed in your question, Set the values as mentioned below: Icon ↑ Coreen) when value is >: Value 70 1 Tube Nunber V (Yellow) when to and V 50 Number J (Red) when so 1 Note 2 ( where where bones are made u Need to fill values. bones are not made default data (No change Required) To demonstrate the above steps I have added picture of murosoft encel sheet. Refer first picture for Steps 1 to steps Refu second picture for thebze Third Picture shows Result Additional Note - Y at all you face difficulty in reaching desired anamnen, kindly comment on answer with your query. I will try to get you the answer as possible e soon