Condition BLUE

[Paul Black]

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]

Check your other post.

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