Condition BLUE
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
|