I’m trying to create a register of pupils where junior pupils (years 1 to 6) are highlighted in yellow.
Year number is in column C. I have created a style (called Junior) which sets the background to yellow, and then a conditional formatting rule for the range A6:R6, using a formula which references C6. If the value in that cell is >=1 and <= 6 the rule should apply the style “Junior” to A6:R6.
The conditional seems to work, but only the cell A6 seems to be formatted.
A small demonstration file is attached - it has no pupil names in it.
If anyone can tell me what I’m doing wrong I would be most appreciative.
I’ve tried this with both 220.127.116.11 (Debian Stretch) and 18.104.22.168 (Debian Buster) with the same result.