Hello

I want to set the 'fill' colour of a cell according to the data in that
cell, so if the cell contains 1 it is filled red, 2 is blue, etc etc. No
problem, I can do this with conditional formatting - format the cell's fill
colour.

I then want to make the underlying data itself invisible. No problem, I use
conditional formatting to make the data font colour the same as the fill
colour.

But what if I want to add a gradient or pattern to the cell's fill colour ?

I cannot find how to make the cell data invisible when I use a pattern or
gradient for the cells 'fill' colour ?

Am I missing something simple ?

Thanks as always

K