[Yr11 Information Technology] OT Excel Formulas help

[Lappin, Jason M]

Hey List....
I was wondering if there was anyone that had a shortened U2O3 SAC. We have a headstart program at our school and our Yr 11 course is cut short by 2 weeks. I am looking for a shortened SAC to satisfy the outcome. I have only used a longer (8 period SAC in the past)
Any help would be hugely appreciated.
Regards,
 
Jason Lappin
Year 10 Co-ordinator 
Rutherglen High School
________________________________

From: yr11it-bounces at edulists.com.au on behalf of Bane, Janet A
Sent: Mon 27/10/2008 9:13 AM
To: Year 11 Information Technology Teachers' Mailing List
Subject: RE: [Yr11 Information Technology] OT Excel Formulas help


Hi sylvia
 
I think you would have to use conditional formatting.  I have attached an example using Office 2007.  Not sure if the same range of options is available in previous versions.
 
regards, 
 
Janet Bane
Patterson River SC

________________________________

From: yr11it-bounces at edulists.com.au on behalf of Mike Brookes
Sent: Sun 26-Oct-08 12:56 PM
To: Year 11 Information Technology Teachers' Mailing List
Subject: Re: [Yr11 Information Technology] OT Excel Formulas help



Sylvia Pastore wrote:
> Hi there
> 
> I was hoping someone can help. In an excel spreadsheet i am trying to
> find out cells that end in a letter such as X and then color those
> cells. Is there a formula that can do it. The find and replace tool is
> too cubmersome and I am sure I have done soemthign similar but cant
> think thanks
> 
>
> Sylvia
>
> 
>
> 
>
> _______________________________________________
> http://www.edulists.com.au <http://www.edulists.com.au/>  <http://www.edulists.com.au <http://www.edulists.com.au/> > - FAQ,
> resources, subscribe, unsubscribe
> Year 11 IT Mailing List kindly supported by
> http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html
> <http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html%20>
> - Victorian Curriculum and Assessment Authority and
> http://www.vitta.org.au <http://www.vitta.org.au/>  - VITTA Victorian Information Technology
> Teachers Association Inc
Hi Sylvia
1.Select the cells that you want to check (eg B5:B60)
2.Select "Format" then "Conditional Formatting" from the Menu
3.Change "Cell Value Is" to "Formula Is"
4.Type in the formula =RIGHT(B5,1)="x" - Note type in the cell reference
of whichever cell is first in the list you have selected and use
relative reference not absolute reference so that the formula will
change for the other cells automatically.
5.Click on the Format button then change the pattern to whichever colour
you want
6. Click OK a couple of times and Voila!

Mike Brookes
Copperfield College

_______________________________________________
http://www.edulists.com.au <http://www.edulists.com.au/>  - FAQ, resources, subscribe, unsubscribe
Year 11 It Mailing List kindly supported by
http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html - Victorian Curriculum and Assessment Authority and
http://www.vitta.org.au <http://www.vitta.org.au/>   - VITTA Victorian Information Technology Teachers Association Inc



Important - This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education and Early Childhood Development.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 7189 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/yr11it/attachments/20081027/e352c808/attachment.bin