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 ...
5th January 2007, 12:55 PM #1
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?
5th January 2007, 01:12 PM #2
- Rep Power
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).
By blackcat in forum General Chat
Last Post: 22nd December 2007, 11:30 AM
By TechSupp in forum General Chat
Last Post: 2nd November 2007, 11:08 PM
By paulpmp4 in forum Virtual Learning Platforms
Last Post: 29th October 2007, 11:50 AM
By Uraken in forum How do you do....it?
Last Post: 18th October 2007, 03:07 PM
By russdev in forum General EduGeek News/Announcements
Last Post: 30th June 2006, 02:03 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)