Condition BLUE
First, I think I would use two separate columns--one for the number and one for
the +.
But you can try this:
Select your range (I used A1:a15) and with A1 the activecell:
Format|Conditional formatting
Formula is:
=AND(--(SUBSTITUTE(A1,"+",""))=0,--(SUBSTITUTE(A1,"+",""))<3)
(and give it a blue format)
And add another formula:
=AND(--(SUBSTITUTE(A1,"+",""))=3,--(SUBSTITUTE(A1,"+",""))<7)
(and format it red)
The =substitute() replaces the + with "" (nothing) and the -- converts the text
(it's a string) to a real number.
Paul Black wrote:
Good afternoon everyone,
I have a column of figures such as ...
0
0+
1
1+
2
2+
3
3+
4
4+
5
5+
6
6+
... and I would like to conditionally format them RED for 0 to 2+ and
BLUE for 3 to 6+ please.
I used a formula to calculate these and then concatenate to get the +.
Thanks in advance,
Paul
--
Dave Peterson
|