Color Grades For Multiple Conditions

Hello House,

I have this template that picks data from another set of worksheets. However, the major challenge i am having is with the color grades.

I want a scenario where the conditions start with category A:


CATEGORY A
If a cell, eg B4="X", it should be colored yellow; however if B4="", it should be colored green.



CATEGORY B
If G4=B4 and are both empty, color green;
If G4=B4 and both contain "X", color orange;
If B4="X" but G4 is empty, color green;
if B4 is empty but G4="X", color yellow.


CATEGORY C
If L4=G4=B4 and all contain ""X", color red;
If L4="X" but G4 is empty, color yellow;
If L4=G4 and both are empty, color green;
if L4=G4="X" but B4 is empty, color orange.


In summary,

Empty cells are meant to be green.
If two consecutive cells in two categories contain "X", color orange.
If three consecutive cells in all three categories contain "X", color red.
If a cell is yellow in Cat. A, but green in cat B, then it can only be yellow in cat. C if it contains "X".


I look forward to your help guys. Find attached.

Thanks Richard for your prompt response. However, there is no inconsistency in my request.
As for your observations,
G5 is what is supposed to be colored Orange and not G6; yet it was colorless (Help needed)
Likewise, H6 was supposed to be colored orange, but it was colorless as well (Help needed)
And all others too.

If you read my request very well, I didn't state that i know how to do it. The attached was for a guide and for the conditional formatting to be applied by whoever knows it. That is why i stated what i want in stages.

Therefore, kindly ignore the formulas in the cells and act on my explanations.

Thanks.

Thanks Richard,

This is the desired result. Manually colored.

It worked. Thanks.