Question

Fill the column in any one colour (red or green) so that the highest values have darker shade of the colour and the lowest values have the lightest shades of the same colour.​

Answer 1

Explanation:

where is the column..

please post it properly...

Answer 2

Answer:

Explanation:

Step 1: Select the first cell of the column and press ctrl+shift+down arrow key  to select the column.  

Step2:  > Conditional Formatting > Data Bars > More Rules

Step3: New Formatting Rule window will open. Change the Format Style from Data Bar to 2-Color Scale and Color to Red or Green > OK.