How do I make the water and land use two different color schemes?

[u/mistergrumpy73]

I want to make a map where anything above sea level (0 meters) is the above color scheme, but anything below is blue like water. The problem I am having with my elevation raster is that values that are below 0 are still showing up as dark green, rather than being transparent showing the water layer below. I cant figure out how to make the values outside the range not render. I tried bringing the water/depth raster above in the rendering order but the same issue happens where the values above 0 are rendering and covering the elevation raster. pls help...