| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting cell
I have used excel to prepare 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 9 Fail Because of the IF function used for the grade and remarks columns, they output "9" and "Fail" respectively even when there were no names. Please is there any way I can First have a function that would allow the name, mark, grade and remark colum to be empty UNLESS when data is input into them? Second, what function can I use for changing the colour of the remark depending on the output. For example, red for a student that failed. thanks, bimseun |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Formatting Conditional On Other Cells Fill Color? | Excel Worksheet Functions | |||
| Applying conditional formatting to cell based on another cell's in | Excel Discussion (Misc queries) | |||
| Conditional Formatting For A Cell Other Than The One With The Form | Excel Worksheet Functions | |||
| Can you apply split colour formatting to the same cell? | Excel Discussion (Misc queries) | |||
| Transfer Cell Formatting for linked cells | Excel Discussion (Misc queries) | |||
Threaded Mode
