 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / May 2006Conditional formatting works, is there a better way?
Using Excel to track students' grades on weekly quizzes, scored 1-10. Each week, the results are posted. According to policy, we are allowed to post scores of 9 or 10. We print the entire student list with the grades but before doing so, using Conditional Formatting we format 'cell value is less than or equal to 8' change the font to white, and all the scores disappear. Is there a macro I could use for the target cell so that when printing, the low scores would not print without using Conditional Formatting? Thanks! > Using Excel to track students' grades on weekly quizzes, scored 1-10. Each > week, the results are posted. According to policy, we are allowed to post [quoted text clipped - 7 lines] > > Thanks! Select the cells you don't want to print. (multiple selections will work) Run the code shown below. Run the macro again. Better? '----- Sub HideTheBadNews() If Selection.NumberFormat = "General" Then Selection.NumberFormat = ";;;" Else Selection.NumberFormat = "General" End If End Sub '---------- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "James E Middleton" <someone@microsoft.com> wrote in message Using Excel to track students' grades on weekly quizzes, scored 1-10. Each week, the results are posted. According to policy, we are allowed to post scores of 9 or 10. We print the entire student list with the grades but before doing so, using Conditional Formatting we format 'cell value is less than or equal to 8' change the font to white, and all the scores disappear. Is there a macro I could use for the target cell so that when printing, the low scores would not print without using Conditional Formatting? Thanks! Thanks, I'll give it a try today and post my results, hopefully, my success! While I'm here... I'll ask you this: Is there a way to add code to that to make the cells with the number 10 highlighted in a different color, or should I stick to Conditional Formatting for that? > Select the cells you don't want to print. > (multiple selections will work) [quoted text clipped - 31 lines] > > Thanks! Since you are selecting the cells you don't want to print, it would be difficult to affect cells outside of the selection. Why don't you just conditionally format the cells to color all grades of 10. Don't use any other cf conditions on those cells. Then just select grades of 8 or less and run the macro I submitted. Note: the macro code assumes the grades are number formatted as "General".  SignatureJim Cone San Francisco, USA http://www.officeletter.com/blink/specialsort.html "James E Middleton" <someone@microsoft.com> wrote in message Thanks, I'll give it a try today and post my results, hopefully, my success! While I'm here... I'll ask you this: Is there a way to add code to that to make the cells with the number 10 highlighted in a different color, or should I stick to Conditional Formatting for that? "Jim Cone" <jim.coneXXX@rcn.comXXX> wrote in message > Select the cells you don't want to print. > (multiple selections will work) [quoted text clipped - 28 lines] > the low scores would not print without using Conditional Formatting? > Thanks! Why use a macro (that is not automatic, you have to select it to run it) when built-in functions like conditional formatting are available (and very easy to apply in this case)? Biff > Thanks, I'll give it a try today and post my results, hopefully, my > success! [quoted text clipped - 39 lines] >> >> Thanks! Wouldn't another simple way to do this be to have a column (C) that holds the actual grades and then a "print" column (D) with a formula like, "=IF(C2<9,"",C2)", then you jus hide the grades column before printing? > Using Excel to track students' grades on weekly quizzes, scored 1-10. Each > week, the results are posted. According to policy, we are allowed to post [quoted text clipped - 6 lines] > > Thanks! Here's what is did: Two worksheets: 'Grades' & 'Print-out'. Linked the cell from 'Grades' to the 'Print-out' sheet. Conditional Formatting as described below. Originally, I asked because we were cutting and pasting, and sometimes the format would be lost. Now, when we enter the grades, the 'Print-out' sheet is created simultaneously without having to cut and paste. Thanks for all the input! > Wouldn't another simple way to do this be to have a column (C) that holds > the [quoted text clipped - 15 lines] >> >> Thanks! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.