Conditional Formatting

[Grover]

Hi
I would like to format 2 or 3 cells based on the colour of another cell
So when the cell goes to Red i want the other cells to have no fill
Any other colour and they display their information
Help much appreciated

 

[bobsan42]

Check these posts
https://www.mrexcel.com/forum/excel-questions/1090639-formatting-cell-value-based-another-cells-colour.html

https://www.mrexcel.com/forum/excel-questions/1090644-weird-udf-problem.html

Frankly I would recommend you think for another way to make CF conditions - base it on a value.