Conditional formatting using formula to select color from another cell

[plettieri]

Hello all,

It has been a long time since my last post and I see that this has grown very nicely.

I would like to use Conditional format (not use VBA) a range of cells (say a1: f15) so that if the letter "A" appears in any cell in that range and say "A" is in b2, the color in Cell b2 would be converted to the color of k1. What might be the formula to insert to the conditional format condition?

Thanks for looking
plettieri

 

[Joe4]

Conditional Formatting CANNOT look at the formatting of any cell, only the values being returned in that cell.
If the color in the other cell is being returned by Conditional Formatting, you may be able to use the same formatting rules in the Conditional Formatting of the other cells.
If the color is the result of manual formatting, I don't think you can do what you want without VBA.

 

[plettieri]

Thanks for the help...to understand
plettieri

 

[handysmurf]

Ok ... well I had a similar problem ... and got a handy solution ... let me go look up the thread ...

 

[handysmurf]

VBA for conditional formatting

First let me say that I tried for 3 hours to figure this out myself before posting ... to no avail. Second, I want to use VBA to do conditional formatting because the conditional formatting panel becomes too cumbersome ... as I make changes or move things around the whole thing becomes...

www.mrexcel.com

You will have to tweak it to fit your needs ... but this may be your solution