View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] tomfabtastic@hotmail.com is offline
external usenet poster
 
Posts: 13
Default Conditional formatting based on the sum of two cells (Excel 2007)

Hello,

I have two cells which must contain percentages that sum to 100%. I
can apply conditional formatting for when either cell is < 0% or
100%. But how do I apply conditional formatting for when the sum of
both cells does not equal 100% ?

Thanks,
Tom