Home > Software design >  Conditional Formatting Depending Upon Multiple Numbers
Conditional Formatting Depending Upon Multiple Numbers

Time:10-15

I have a column of values that are a number out of 10. So, it could be 2/10, 3/10, 4/10 and so on, all the way up to 10/10. To be clear, these are not dates, but simply showing how many questions the student answered correctly out of 10.

I'm trying to use conditional formatting to highlight them a certain color depending upon the score they got. For 9/10 and 10/10, I'm wanting to use a certain color, but it doesn't seem to be working with REGEXMATCH or with OR. Also wanting to highlight all scores that are 6/10 or lower. I know that I could make this work by applying conditional formatting for each and every score with text contains but the problem I'm finding is that it thinks it's a date.

Is there a way to match multiple scores out of 10 using REGEXMATCH?

enter image description here

now you can use formula like:

=REGEXMATCH(A1; "^9|10\/")

enter image description here

  • Related