Conditional Formatting works on one sheet, EXACT SAME conditional formatting fails on 2ND sheet


Hi Folks

Frustrating issue for me... two sheets, exact same conditional formatting (see attachment).

One sheet, conditional formatting works 100% & the other sheet conditional formatting only partially works (changes the cell colour for my 'Risk Severity' & 'Risk Likelihood' cells but does not populate risk rating nor action columns text...)

Checked -> Rule ARE THE SAME,

Checked -> The processing order are the same

Cant see any other influences, linked cells etc...

Stumped and more than a little frustrated

Thanks in advance.