[Yr11 Information Technology] OT Excel Formulas help

[Mike Brookes]

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> - 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 - 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