Hey,

I want to automatically change the transparency or colour of a cell based on its value. If it is 100 I want it to be fully transparent; 0 I want it fully opaque. If it's 46, I want it 46% transparent. Obviously conditional formatting won't do this as I need an infinite number of conditions,