Conditional formatting in a single cell based on "IF" formula

kyletds

I have a simple function I'd like to use. IF cell A2 is greater than cell A1, then format the background of the cell green. If cell A2 is less than cell A1, then format the background of the cell red. 

Can this be done? Please help and thanks. 

Mike Wilday

Yes. You will want to use conditional formatting. See the screenshot below. You will need to set a rule for red formatting and a separate rule for green formatting.