[Yr11 Information Technology] OT Excel Formulas help

[Bane, Janet A]

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: 189403 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/yr11it/attachments/20081027/84311265/attachment-0001.bin