Sorry had to do work.....
To make things a bit more simple just do a normal if statement on the results page, then do a conditional format on that (see attached)
Just as i side note, i would change the layout of your data, it might take you a while but it will save you from a whole world of pain later on - the school would be at the top and the date down the side
Obviously its your call but it will make getting data out and displaying it much much easier and more useful
fyi i changed the number in p68 to get a red cell on the sheet1
Last edited by Purfleet; 07-03-2020 at 11:59 PM.
Reason: typo
|