Conditional Formating

  • Thread starter Thread starter Roger R
  • Start date Start date
R

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??
 
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.
 
Thanks for giving this a shot, but I have thought of these
options. the problem is that I need to send the sheet out
and have other users populate these cells, so I can hide
the number with formatting, I need the cells blank.
 
Back
Top