Conditional Formating

[Roger R]

This might be a tough one. I'm trying to color code a
spearsheet according to product availibility. This spread
sheet will also be used to order product. So I put the
product availibility into the correct cells, then use
conditional formatting to color block those cells
according to the qty. Now I want to remove the text
(value), but retain the color block. Any clues??

 

[bj]

If you just want the numbers to not show, as part of the
conditional formating you can set the cell number custom
format to ;;;. This hides the text in the Cell. If you
want to hide the data from the formula bar. you can
select hidden in the cell format security section and
protect the sheet.