1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. Hi Guest, welcome to the TES Community!

    Connect with like-minded education professionals and have your say on the issues that matter to you.

    Don't forget to look at the how to guide.

    Dismiss Notice

Conditional Formatting - targetting columns (Excel 2003)

Discussion in 'Computing and ICT' started by Blissx, Oct 17, 2011.

  1. Not sure about the VB code but I have used Excel to work out averages and colours for meeting targets etc. Message me your email address and I will send you my "How To" Video I created for other staff at my school using CamStudio, if that helps?
     
  2. hoof_hearted

    hoof_hearted New commenter

    I use a nested IF statement to change a numerical value to letters, then conditional formatting if cells is equal to C format green etc, is that what you mean?
     

Share This Page