No, pattern only applies to the fill, so you can't totally hide the value if
you must have pattern as well.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"KRK" wrote in message
...
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