Conditional Formatting Related Problem

[PK Sethi]

I am attaching an Excel File. I have Conditional Formatting of Cell B.

I want Column C & D also to have same colors as that of B. I need help to how to do this.

Thanks if I get solution to my Problem

PK Sethi

 

[Luke M]

Hi PK Sethi, and welcome to the forum.

Unfortunately, there is no easy way to do what you asked.
http://www.excelforum.com/excel-for...-formatting-based-on-another-cells-value.html

You could try to mimic the formatting by using some fancy VB to color each cell, but with the wide range of colors possible, you'd need to code each color.