Hi all, a little stuck here and think i might have part but not all the answer.
I have cell which are populated with a department name, IE Maths / English / History blah…
I would like to change the background colour of that cell depending on the department. Here is what i have so far.
if($dept == "") {$deptcolour = "White";}
if($dept == "No") {$deptcolour = "Red";}
if($dept == "SEN") {$deptcolour = "Yellow";}
if($dept == "Admin") {$deptcolour = "Orange";}
if($dept == "Science") {$deptcolour = "Green";}
if($dept == "Maths") {$deptcolour = "blue";}
It seem to be partly working but then does highlight other cell that are not specified. Top one left blank for unselected department.