Thread: How do I colour ill a cell in excel with a formula?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SLO SLO is offline
external usenet poster
  
Posts: 1
Default How do I colour ill a cell in excel with a formula?

I am trying to figure out how to automatically colour a cell in excel if
my "IF" statement turns out to be negative. For example I have a list of
prices in excel, and if they are $50 higher or $50 lower than the
targeted price I need that to be flagged somehow in excel (preferably
by filling it in with a different colour). Currently I am going through
the prices manually and this just takes up too much time!! Help me!


--
SLO
------------------------------------------------------------------------
SLO's Profile: http://www.excelforum.com/member.php...o&userid=35450
View this thread: http://www.excelforum.com/showthread...hreadid=552262

Reply With QuoteReply With Quote