CF Related Query

[Jagdev Singh]

Hi Experts,

I am trying to use the below excel formulae in the form of conditional formatting, but it is not working. Is there any specification to apply the below formula in the form of CF. I am bit confused what I am doing wrong here. Is it not working because of the word “Pending” and “Done” used in the formula.

=IF($K2="","",IF(AND($K2<>"",$O2=""),"Pending",IF(AND($K2<>"",$O2<>""),"Done","")))

I am adding it in column P.

Regards,

JD

 

[Chihiro]

For CF you don't use "IF"

What you'd do is break each IF statement to individual CF and then apply STOP IF TRUE (if needed).

See below links:
http://www.exceltip.com/tips/conditional-formatting-with-if-statement.html
http://www.mrexcel.com/forum/excel-questions/348416-conditional-formatting-if-statement.html

 

[Jagdev Singh]

Hi Chihiro,


Thanks for the links they are informative. I will try to adopt the concept; I have so many if statements in my formula have to drop them throughout the formula. I will try to make it workable thanks again.


Regards,

JD