I am trying to create a sheet with no code so it is easily maintained. I need
to put in some conditinal formatting but can't get my conditions to work
together.
I have two columns spec and results -
Condition 1 - If spec has contents and results is empty turn cell blue, when
results is filled or spec is empty i need results to be white
Condition 2 - I need the condition to recogine if the entry in spec is a
single number or a range (ie. 11 or 10-12). then i need anything not matching
the one number or in the range to be red and anything with in the range or
matching the number to be green, but only if there is contents in the spec
cell.