View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John Moore John Moore is offline
external usenet poster
 
Posts: 70
Default More than 3 Conditions

Hi, I am looking for a code which will do the following for me

Range is T5:T90
Condition 1: If Cell value is 10 make background light blue
Condition 2: If cell value is between -10% and -20% make background yellow
Condition 3: If cell value is < -20% make background red
Condition 4: If cell value is < 10% but 0% make background green.