Conditional Formatting
Some of my cells on my spreadsheet need to be the same color as the previous cell but the cell I need to be the same color will always be changing value but it will always be the same color as the previous cell. For instance, any cells that contain the text "Above Average" are orange and the following cell, regardless of the value needs to be the same color as the "Above Average" cell because the two will always be the same value. If it says "Average" and is yellow then the following cell needs to be yellow also. How do I form and apply that rule?