View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Teri Teri is offline
external usenet poster
 
Posts: 77
Default Conditional formatting

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?