The column that I want to format is inventory days in house based off avg daily usage.
There are 1170 item numbers with inventory days ranging from 0 to 12125
I want to have a "heat map" looking format where 60 days is green (preferred) and the farther the inventory moves from 60 days the closer to red (not preferred) the cells get.

I was trying to use color scale conditional formatting and tried to put a formula in but could not get it to work because it can't reference cells (I think?).

Can anyone help, or just provide a better definition of what type of formula I could use?