branston
03-06-2020, 04:32 AM
Hi
I am trying to apply some conditional formatting (to cells B3:B22 on 'main' sheet) by checking whether candidates have left the topic question "blank" ie. have NOT attempted the question in which case the 'score' cell on 'scores sheet' would be recorded as a blank (as opposed to a 0). If they attempt the question but get no marks then a '0' is recorded.
I have attached my sheet and the 'yellow' coloured cells on the 'main' sheet are what I would like the finised product to look like. At the moment, for demo purposes, I have manually highlighted them yellow.
Is this possible on a range of cells? Or is there another way of doing it with/without a VBA macro? Any help would be greatly appreciated.
Many thanks
I am trying to apply some conditional formatting (to cells B3:B22 on 'main' sheet) by checking whether candidates have left the topic question "blank" ie. have NOT attempted the question in which case the 'score' cell on 'scores sheet' would be recorded as a blank (as opposed to a 0). If they attempt the question but get no marks then a '0' is recorded.
I have attached my sheet and the 'yellow' coloured cells on the 'main' sheet are what I would like the finised product to look like. At the moment, for demo purposes, I have manually highlighted them yellow.
Is this possible on a range of cells? Or is there another way of doing it with/without a VBA macro? Any help would be greatly appreciated.
Many thanks