Conditional - All cells color scale, but ignore above or below certain values?

[halloo2]

1
2
3
4
5
6
color all cells >=3 with incremental colors

[LeroyG]

If you do not count white as a color…

LibreOffice 7.2.7.2.

EDIT: Middle value could be 3 (not 2.99).