Excel, Conditional Formatting
I have five values - 1 to 5.
Data bar (Gradient Fill) shows small bar on 1, and full cell bar on 5. I want to show the reverse.
On 1, it should show full bar, and on 5 it should show small bar.
Hope I am clear.