View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mphell0
 
Posts: n/a
Default How do I change cell color based upon data range within the cell?


Go to Format-Conditional Formatting

Set your criteria and click the Format button to set your colors,
borders etc.


--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=519504