+ Post New Thread
Results 1 to 2 of 2
General Chat Thread, Excel IF statement maybe VB in General; member of staff would like to compare national curriculum levels in excel spredsheet, and give an indication of wether the ...
  1. #1

    Join Date
    Apr 2006
    Location
    UK
    Posts
    939
    Thank Post
    39
    Thanked 70 Times in 54 Posts
    Rep Power
    30

    Excel IF statement maybe VB

    member of staff would like to compare national curriculum levels in excel spredsheet, and give an indication of wether the level has gone up, down or stayed the same. If level was 5 in Year 8 and in Year 9 it is 6 colour the cell red, if it has stayed the same = amber and down - you guessed it Red?

    Is there anyway i can do this? compare then two numbers and colour a cell/multiple cells depending on result?

    Dan

  2. #2

    Join Date
    Jan 2006
    Posts
    143
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: Excel IF statement maybe VB

    Conditional Formatting will do this, you will need to base it on a formula comparing the two cells rather than the value of a cell (it's a dropdown in the dialog).



SHARE:
+ Post New Thread

Similar Threads

  1. Best Mission Statement Words
    By blackcat in forum General Chat
    Replies: 10
    Last Post: 22nd December 2007, 11:30 AM
  2. Excel Problem
    By TechSupp in forum General Chat
    Replies: 0
    Last Post: 2nd November 2007, 11:08 PM
  3. Vision Statement
    By paulpmp4 in forum Virtual Learning Platforms
    Replies: 5
    Last Post: 29th October 2007, 11:50 AM
  4. excel in explorer
    By Uraken in forum How do you do....it?
    Replies: 2
    Last Post: 18th October 2007, 03:07 PM
  5. Positional Statement: Managed Services Doc Views Wanted
    By russdev in forum General EduGeek News/Announcements
    Replies: 21
    Last Post: 30th June 2006, 02:03 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •