Set the color of a cell based on the color and text of another cell.

[ajsmiles0613]

I am looking for a formula that does one of the following:
If a cell with text is filled with a color, then all other cells with the same text will automatically be filled with the same color.
OR
If a cell with text is filled with a color, then entering the same text in a cell will automatically fill with the same color.
OR
Setting a cell equal to the same text and color fill as another.

For context, I have a sheet with many rows with 9 columns. For every row, the first 2 cells contain different text and one of them will eventually be filled yellow. The other 7 columns contain text from either one of the first two. I want so that when I fill one of the first 2 yellow, the other cells that contain the same text will automatically be filled with the same color.

I'm guessing this can be done by formulas with conditional formatting or maybe VBA, but I'm not sure.

Thank you!

[Special-K]

Dunno if this has changed recently but formulas cannot read the colours of cells unless the cell has been filled using Condtional Formatting (in which case just use the same codntion to dtermine if the cell is filled with a specific colour), otherwise VBA would be you're only solution. But as you've posted this in the formula area, I'm assuming that's the solution you prefer which as stated may not be possible.

You can read the contents of a cell and set the colour accordingly.

Post a sample spreadsheet with expected results, remove any sensitive data, create a mockup example if necessary.
Use the Go Advanced option at the bottom of the page then scroll down to Manage Attachments as the "paperclip" method does not work on this forum.