Thread: Change the color of a cell change dependant on a result
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jan Karel Pieterse Jan Karel Pieterse is offline
external usenet poster
  
Posts: 535
Default Change the color of a cell change dependant on a result
Hi KFEagle,

I need to make a cell change color dependant on a formula.
For example, if sum(A1+A2)=100 then change cell color to red


Insert that formula into the Formula Is option of the Conditional
formatting dialog (Format, Conditional format)

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

Reply With QuoteReply With Quote