Conditional Formatting

[nathanmav]

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!

 

[nathanmav]

actually the X that you put in the Column Q is the one that should be highlighted in red because they are not approved or still not close.

 

[James006]

Quite frankly ... I do have the feeling you are changing your mind ... or that you are still building your own structure ...

As a consequence ... I am at a loss ...

 

[nathanmav]

Sorry james006 yes im building my own structure because that the output i want to get. i send you PM regarding the sample 3 with my formula because i analyzed again the data i have enter STATUS C total is still 14 and that 14 statuc C is the one that should be highlighted.. sorry again james006..

thank you again for your help and ideas!

 

[James006]

From 13 to 14 ... this means ..there is ONE additional case you have identified ...

So what is the rule you picked to add this additional case ...???

 

[nathanmav]

yes.. did u check the sample i send you in PM? the problem in that formula is that the STATUS C that i refer to the approved reference no. should be highlighted in white.