View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Francisco Rodriguez[_2_] Francisco Rodriguez[_2_] is offline
external usenet poster
 
Posts: 9
Default Formula for changing cell format based on more than 3 values

Hello,

I was wondering how could it be possible to change the format (color to be
exact) of a cell based one of 5 possible values (for example: 1=red; 2=pink
or magenta; 3=orange; 4=yellow, 5=light cyan). Conditional formatting only
does this for three possibilities.

Thanks,

Francisco Rodriguez