Fill the column in red and green so that the values above a certain number (say 3000) are highlighted in a gradient of red and the ones below the number are highlighted in a gradient of green.
Answers
Answered by
0
Answer:
where the column and color boxes
Answered by
16
Answer:
Yes ,it is possible.
we just need to select the column (ctrl+ shift +down key) in the conditional formatting we can find colour scale and then again from conditional formation option select manage rules and from 2-color scale it can be achieved by putting number number in lowest and highest values accordingly
Explanation:
Similar questions