I would like to create a rule in my spreadsheet that is similar to conditional formatting, but instead of filling a format, values are inputted. For example I would like to fill a cell with the value "AG" and the two cells to the right fill with the value "O". I am using excel 2013, and saw the lightning fill button. this may work, but I can't tell because every time I try and open it, my spreadsheet stops responding and I get a dialog box requesting to restart the program and recover the spreadsheet. Does anyone have a way of creating this rule? Thanks!