| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what to do with unused cells
When doing a perpetual inventory how do i black out the cells that are not
used after moving on to a new line with inventory updates. (so when others enter information they enter it into the correct place) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
what to do with unused cells
Assuming the cells you want to format ar blank, use Formatconditional
Formatting with settings "is equal to" and criteria ="" Set format patterns to black -- RWS "B" wrote: When doing a perpetual inventory how do i black out the cells that are not used after moving on to a new line with inventory updates. (so when others enter information they enter it into the correct place) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumif Cells Are Not Blank | Excel Worksheet Functions | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Is there a way to cut off unused cells on a sheet | Excel Discussion (Misc queries) | |||
| Help adding text values | Excel Worksheet Functions | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Linear Mode
