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

Check your other post.

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