My first post so....
Hello Excel Forum Users,
Im looking to use either conditional formatting or VBA to automatically change the colour transparency of a cell depending on a value between 0 and 1. The resolution of the values is 0.01, so there will be 100 different transparency values so to speak. I need to do this in a a block of cells between B2 and F37.
(Specifically it's for a lab project where we're analysing the fringe pattern on the soundboard on an acoustic guitar, exciting stuff)

Thanks to anyone generous enough to spare their wisdom.
Paul