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.
Hi Hans!!! I've already created the Conditional Formatting based upon the Text however, I'd like the adjacent Cells color to change when C3 changes (based upon the E2 content). So when C3 changes to Yellow, I'd like for B3 to change to Yellow too. I hope that makes sense. 🙂
You'll have to create as many rules for B3 as for C3 - as described in my previous reply.
