Excel color scale with outlier

I'm working with valuta in Excel and need to visually represent the biggest expenses for my job. Here is an example of how I do it now:

It's a simple 3 color scale from green to red via yellow with green as minimum, yellow at 50 percentile and red at maximum.

You see that there isn't a lot of difference in color for the numbers between 0 and 25 euro.

Is it possible to detect the outlier(s) (can be multiple) and "ignore" that one for the lower values? I'd like something similar like I have but with more visible color variation on the lower end of the spectrum.

Solution 1:

You can set "minimum value" for conditional formatting, this case Excel will consider everything below that to be coloured as minimum and won't calculate with the whole range: