Conditional formatting
Set your thre CF conditions as beow:
Green
=OR(A1="1+",A1="1",A1="1-",A1="2+",A1="2")
Amber
=A1="2-"
Red
=OR(A1="3+",A1="3",A1="3-",A1="4")
HTH
"Teri" wrote:
I have cells with the following information in them and need to apply CF:
"1+" - the cell need to be Green
"1" - the cell need to be Green
"1-" - the cell need to be Green
"2+" - the cell need to be Green
"2" - the cell need to be Green
"2-" - the cell need to be Amber
"3+" - the cell need to be Red
"3" - the cell need to be Red
"3-" - the cell need to be Red
"4" - the cell need to be Red
Can it be done?
|