View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tj tj is offline
external usenet poster
 
Posts: 71
Default Change Font Color Based on Conditional Formatting

I want to compare two coluns of sales data (column A has 2007 Sales, Column B
has 2008 Sales) with the percentage of change in column C. If the percentage
of change is positive and greater than 75% I'd like to have the result show
in Green, if it is negative I'd like the result to be in Red, all other
changes can be in black. Is that possible, and if so how? Thanks for any
assistance with this!