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.
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.
By when the issue will be resolved?
Hi, I'm currently experiencing an issue with Repair Tracking smartsheet, which was created about three weeks ago. When attempting to access it, the page takes an unusually long time to load and eventually displays the following error message: Interestingly, other Smartsheets I’ve created are working fine—this issue seems…