Conditional Formatting Referencing Color of Another Cell

[masouder]

I am trying to create conditional fomatting that changes the background color of a cell based on a simple conditional formula, but I want the color to come from the background color of another cell.

For example, assume I want to create conditional formatting that changes the background color of cell A1 based on the conditional formula "=A1=1". But instead of selecteing the backgroud color in the Conditional Formatting Rule Manager, I want the color to be based on the background color of cell A2. So if cell A1 contains the value 1 (meets the condition) then I want the background color of A1 to change to the current background color of cell A2.

Is this possible?

 

[Fluff]

Not with conditional formatting, I'm afraid.

 

[pgc01]

... So if cell A1 contains the value 1 (meets the condition) then I want the background color of A1 to change to the current background color of cell A2.

Is the background colour in A2 random or is there some logic to it? If the latter is true you can use the same logic.

 

[masouder]

The user can change the background color of cell A2 at any time, and when that happens the background color of A1 should change too.

 

[pgc01]

In that case I'll repeat what Fluff said: Not with conditional formatting, I'm afraid.

 

[masouder]

Thanks, all. I didn't think it was possible, but wanted to be sure. Would be a good feature, as I have had this need more than once.

 

[Fluff]

Sorry we couldn't be of more help.