Thread: Condition BLUE
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Black Paul Black is offline
external usenet poster
 
Posts: 394
Default Condition BLUE

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