Conditional Formatting Referencing Color of Another Cell

masouder

New Member
Joined
Jul 5, 2013
Messages
48
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,298
Office Version
365
Platform
Windows
Not with conditional formatting, I'm afraid.
 

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,732
... 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

New Member
Joined
Jul 5, 2013
Messages
48
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

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,732
In that case I'll repeat what Fluff said: Not with conditional formatting, I'm afraid. :(
 

masouder

New Member
Joined
Jul 5, 2013
Messages
48
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,298
Office Version
365
Platform
Windows
Sorry we couldn't be of more help.
 

Forum statistics

Threads
1,077,951
Messages
5,337,381
Members
399,144
Latest member
Lauren Ward

Some videos you may like

This Week's Hot Topics

Top