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

On Oct 19, 6:28*am, 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

If range of cells is A1:A15
Condition 1
Formula Is =VALUE(LEFT(A1,1))<3
red format

Condition 2
Formula Is =VALUE(LEFT(A1,1))=3
blue format

Ken Johnson

On Oct 19, 2:02*pm, Ken Johnson wrote:
On Oct 19, 6:28*am, 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

If range of cells is A1:A15
Condition 1
Formula Is =VALUE(LEFT(A1,1))<3
red format

Condition 2
Formula Is =VALUE(LEFT(A1,1))=3
blue format

Ken Johnson- Hide quoted text -

- Show quoted text -

Thank you both for the help, it now works great.

Thanks,
Paul