Conditional formatting

[Guest]

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?

 

[Guest]

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

 

[Lacty]

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?

I don't know if that can be done but there are a lot of ways to get
around problems in Excel.

You could try to insert a dummy column and for every value that you
want it to be formatted as green give it a 0, for Amber give it a 1
and for Red a 2. Then you can do your conditional formating based on
that dummy column.

If it works hide the dummy column