Excel 2007 : Using 'OR' 'AND' in Conditional Formatting

[raavi_143]

Hi,
I have a problem with conditional formatting. Let’s say cell Lj has four values A, B, C, D based on these reading I need to do conditional format some part of the worksheet area. If Lj has ‘A’ I have a different kind of formatting, similarly if Lj has B my formatting rule changes. Formatting is to tell pass fail criteria. Please help how to do this. I tried using different rules like format based on pass fail criteria and then check if Lj has the values corresponding to the formatting and stop if true. But this is not working as my formatting rules lies in a small range between k and l. For the above said method I am using two rules and what if all my rules fail then still my values will lie in the range and will have the conditional formatting rule applied. Can I do this by using formula, help me on how to do this using ‘IF, then else’
Any ideas on how to do this is appreciated.
Thank you!