How can I colour code an attendance log using code or macros?

B

Boolian

I have been asked to produce a Attendance Log with is colour coded by the
learners literacy scores and I require some help on how to go about this.

Do I need to use Code or Macros and if so how do I do it?
 
B

Boolian

Conditional Formatting only allows me to colour about three levels but I need
a bit more :(

Is there any way of colour coding a complete line as well as hide the level
column
 
B

Bob I

Scope creep? What version of Excel are you using? 2003 allows for a
veritable rainbow!
 
B

Boolian

Currently the attendance registers are in a Database but I now require them
to be colour coded by the learners literacy levels (Entry 1, Entry 2, Entry
3, Level 1, Level 2, Level 3 etc) but I have been informed that you are not
ale to colour code them using MS Access and that the data needs to be
transfered to Excel (which I can do). My problem is colour coding each
learner by their respected learner level (e.g Level 1's all red, Entry 3's
all blue) but also I need top do it in a way so that the learners don't know
why it is colour coded.

PLEASE HELP! :(
 
B

Bob I

Sounds like will have to resort to a Macro VBA then

Somthing like the following where A2 and B2 contain the first and last
names and C2 contains a number which will set the "background color" of
the range of cells A2:B2. As to "picking particular colors" I suppose
you may use HLOOKUP table to set the C column value to match a color
with a "Level"

Sub Macro2()
'
' Macro2 Macro
' Macro recorded 9/7/2006 by Bob I
'

'
Range("A2:B2").Select
With Selection.Interior
.ColorIndex = Range("C2").Value
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
End With
End Sub
 
Top