Question -

a) Format the table choose your own formatting style.

b) Using conditional formatting assign red color to low profit values between 200000-300000 orange (medium) to values between 300000- 400000 and green color to (high) profit values over 400000.

c) Illustrate the same rule in conditional formatting using three color arrows.

use the link to edit the excel sheet , choose (profit )sheet

https://1drv.ms/x/s!AnxvL31uw0pWhlZEkZN-_DTHPTR3

the result should look like the picture

744 B40 NumCar Avgre 3,267 $104.73 3,205 $109.16 4,068 $103.78 3,487 $106.15 3,214 $180.64 3,5811 $210.07 3,576 $149.26 3,192 $155.65 3,4401 $141.35 3,787 $185.23 3,424 $141.96 3,392 $184.62 3,287 $153.09 3,474 $191.58 3,848 $144.43 3,327 $206.75 3,524 $167.33 OverHea | $136,856 $209,9112 $168,877 $222,0777 $232,2301 $451,3631 $213,4981 $298,1042 $194,501 $420,876 $194,422 $375,739 $201,2851 $399,329 $222,307 * $412,706 $235,8677 Profit $205,284 $139,941 $253,315 $148,051 $348,346 $300,909 $320,246 $198,736 $291,751 $280,584 $291,634 $250,493 $301,927 $266,219 $333,461 $275,138 $353,801 | 252 232 212 548 768 344 568