I wondered if someone could confirm whether it is possible to use conditional formatting to get a cell to change colour based on a colour of another cell?



I have tried to do this and googled it but haven't found anything.

If anyone could help it would be appreciated.

Hi
have a look at this UDF by Chip Pearson

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post