I’m a beginner and trying to create a formula that modifies the contents of Cell A1 based on the color of the cell in B2;
If Cell B2 = [the color red] then display FQS.
If Cell B2 = [the color yellow] then display SM.
This is conditional based on the cell fill color.