Thanks to all for your reply.
I think I have not got what I required.

In my spreadsheet I want four conditional formatings.
If I enter:
Number 1 in any cell the colour should change to Bright Green,
Number 2 in any cell the colour should change to Yellow,
Number 3 in any cell the colour should change to Gold,
Number 4 in any cell the colour should change to Rose.

What I want is that whenever I enter any numbers in any cell in any sequence
the colour as per above should be filled in that particular cell.........but
the value entered should not be displayed......for eg: if I enter number 2,
the cell should change to colour Yellow but at the same time number 2 should
not be visible in that cell.

Cheers,
Mandeep



"gjcase" wrote:


You also can specify a format for neagtive numbers, that can add one

---Glenn


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=522556