Conditional Formatting based on Colours (or Values) on another Column

The attached spreadsheet shows the Marks and % Deviation, both input from another sheet through Formulae only, not as absolute values.

The Marks column is conditionally formatted to show different ranges, whereas the % Deviation column is conditionally formatted to show the Lowest 3 values.

Only for the Lowest % Deviations highlighted, I wish to look up the colours in the Marks column, and based on it, I wish to highlight a cell in M column against the Lowest % Deviation (at M10 and M22 in this case) as below:

(i) If the colours in the 3 cells are equal, I wish the highlighted cell in M column to be Red;
(ii) If the colours in any 2 cells are equal, I wish the highlighted cell in M column to be Green; and
(iii) If the colours in the 3 cells are different, I wish the highlighted cell in M column to be Blue;

I am referring to colours above for easy identification, please note the values are formula-based.

How do I proceed in order to automatically highlight the cell in the M column?

Thanks in advance.

I wonder such Conditional Formatting, based on Colours in another Column, may not be possible in Excel?

@FDibbins

Thanks for the explanations.

You have said, "You may be able to apply similar rules that you have for CF, to the new process you are trying to do".

Can you please provide one single such formula, so that I might be able to expand it for the others?

Also, a minor adjustment to the rules:

(i) If the colours in the 3 cells are equal OR if the colours in the 3 cells are entirely different (that is 3 unique colours), I wish the highlighted cell in M column to be Red; and
(ii) If the colours in any 2 cells are equal, I wish the highlighted cell in M column to be Green

Thanks.

@FDibbins

The set of rules in Marks column only refers to values in the same column. Whereas my new requirement involves the % Deviation column too, specifically to the lowest value in that column.

Sorry, I am new in this area....

Thanks.

I am surprised nobody here was able to / interested to solve this problem. I wonder why nobody even commented about the feasibility to solve it let alone providing a solution.

Anyway, I got a paid solution, which is through using Tables.

Thanks.