I have to compare two different cells and I want one of three different colors to appear and fill a third cell: less than (Green), equal to (Pastel Yellow), and more than (Red). I really have tried to put something together but I just am not familiar enough with the formulas to even know which one I am supposed to use. Every time I try to set something up I either get something wrong and it does not allow the formula to be input at all due to error or it does not give the proper output.
Cell 1 = 1
Cell 2 = 2
Cell 3 = 2 is more than 1 (Red Fill)
Cell 2 has to be compared with cell 1; basically is cell 2 greater than/less than/or equal to cell 1. Once the results are determined to be less than, equal, or greater than I want Cell 3 to be filled green, pastel yellow, or red respectively. How do I do this with one formula? Is that possible?
EDIT: Once the value for cell one or two has been deleted I want the shading for cell 3 to go back to no shading at all. Is that possible in addition to the other formula?
Bookmarks