View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default 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?