Is it possible to set cell formatting in a function statement. For example you use an IF function to determine if the value in another cell is greater than a given value and if the value is true you want the cell background to be red and if it is false you want the cell background to be green. =if(A1>20,background turns red,background turns green). Perhaps a little confusing, but a necessity for a new program I am working on. Thanks for any help.