three conditional foramats

  • Thread starter Thread starter Miree
  • Start date Start date
M

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.
 
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,
Click to expand...

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
Click to expand...

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
 
Back
Top