three conditional foramats

[Miree]

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.

 

[Sandy Mann]

I thnk that you will have to think it through so more or explain what you
want more clearly.

Condition 1 - If spec has contents and results is empty turn cell blue,

Which cell? Spec or Results?

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

Again are you talking about Spec or Results? Depending on which one
Condition 1 may prevent you being able to do Condition 2. Also do you mean
*every* cell to look at *every* other cell?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk