Thread: In Excel is there a function to change a cell's background color?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SVC
 
Posts: n/a
Default In Excel is there a function to change a cell's background color?
Use Conditional Formatting (Format Conditional Formatting): Cell value is
and set your criteria. Click Add to add additional conditions.


"Sireofsix" wrote:

The cell contains a formula to determine the contents. Based upon results, I
would like to color the background of the cell (e.g. if 10 color red; if 10
& <20 color yellow; etc.). I have not been successful in finding a solution
using help. Thanks!
Reply With QuoteReply With Quote