Conditional Formatting Formula By Using Colors In the Cells

Hello JetMc, Thanks for the formula. I found some minor error when applying the formulas. Can you kindly help to sort the points stated on the attached file.

Regards,
Shameen

Further to the post no. 10, I also made another file and made the test. In fact, i am stuck in between and the result attached for your kind information.

Regards,
shameen