Is it possible to format the fill color of a cell to equal the fill color of another cell?

New Contributor

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 Conditional Formatting will Highlight C3 Red, or if E2 contains "SS", Conditional Formatting will Highlight C3 Yellow, etc. (with 12 text conditions equaling 12 different colors.)

I would like B2 (which contains an "@" text) to match the Highlighted color of C3.

Is that possible?  If so, how?  I've spent hours trying to figure this out and you all are my last hope.

Thank you in advance for any guidance.

3 Replies

@MrsJohnson 

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.

@MrsJohnson 

You'll have to create as many rules for B3 as for C3 - as described in my previous reply.