View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sireofsix
 
Posts: n/a
Default In Excel is there a function to change a cell's background col

Excellent! Thank you very much and enjoy your day ! ! !

"SVC" wrote:

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!