Hi everyone i have a conditional formatting formula it change color when the status of a document is "A or B = white, C = Red, UR = Orange & NS or For Signature= Dark Orange".
My problem is the status C it will change the color when i enter B but how can i remove the color if i did not change the status instead i refer it to other reference which is approve.
Apologies if my explanation is not clear.. kindly check my attached sample: https://drive.google.com/file/d/0B6RmsSizixYMbnhaTFZXVWtIbHM/view?usp=sharing.thanks hope someone help me to figure out this problem.. again thank you in advance!
My problem is the status C it will change the color when i enter B but how can i remove the color if i did not change the status instead i refer it to other reference which is approve.
Apologies if my explanation is not clear.. kindly check my attached sample: https://drive.google.com/file/d/0B6RmsSizixYMbnhaTFZXVWtIbHM/view?usp=sharing.thanks hope someone help me to figure out this problem.. again thank you in advance!