R
Roger on Excel
Hi,
Conditional formatting allows for 3 conditions.
I require 6 for the following ranges of data in a field spannin A1 to G50
0-0.1 pale yellow
0.1-0.25 yellow
0.25-1.0 pale orange
1.0-1.5 orange
1.5-2.0 pale red
I guess an IF, THEN statement might work?
Can anyone help?
Thanks,
Roger
Conditional formatting allows for 3 conditions.
I require 6 for the following ranges of data in a field spannin A1 to G50
0-0.1 pale yellow
0.1-0.25 yellow
0.25-1.0 pale orange
1.0-1.5 orange
1.5-2.0 pale red
2.0 red
I guess an IF, THEN statement might work?
Can anyone help?
Thanks,
Roger