View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,comp.apps.spreadsheets
come_mon_come_mon! come_mon_come_mon! is offline
external usenet poster
 
Posts: 21
Default Any method to set cell background color conditionally ?

Hi,

I'm compiling a long list of percentage data stored in a single column
of excel worksheet (say it in column A). I want to label different
ranges of percentages by different colors e.g. 0-20% by yellow, 20-40%
by orange, 41% above by red, etc. How could I do that with excel
function ?