Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formating cell
I have used Excel to set up a mark sheet thus:
Name Mark Grade Remarks Mr x 80 1 Distinction Mr y 30 9 Fail Mr z 65 3 Credit 9 Fail 9 Fail 9 Fail When I do not have names beyond Mr z, the columns for grade and remarks continue to output "9" and "fail". I used the IF function in the formula used for grade and remarks. What can I do so that First, the name, grade and remark column would remain EMPTY except when names and marks are typed in? Second, since this file is shared by may users, how can I hide the formula with a passwprd, but the users can have access to name and marks colun. cheers, bimseun |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formating a cell .. to Show Nothing .. if True | Excel Worksheet Functions | |||
copying cell names | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Cell formating | Excel Discussion (Misc queries) | |||
conditional formating for a blank cell | Excel Discussion (Misc queries) |