Forum Discussion
Is it possible to format the fill color of a cell to equal the fill color of another cell?
I have a spreadsheet with with columns conditionally formatted to fill (highlight) based upon the text of another cell. For example, the formula in C3 is '=$E$2', and if E2 contains "STS" the Condi...
Select B2.
On the Home tab of the ribbon, select Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula =$E$2="STS"
Click Format...
Activate the Fill tab.
Select red.
Click OK twice.
Repeat these steps, but with =$E$2="SS" and yellow as fill color.
Etc. etc.