Conditional Formatting

[gnaga]

I need a formula to format a cell on certain conditions.

For example

Cell to be formated is Cell C10

On Condition If Cell C1 is equal to a text "A" And Cell A10 is equal to a text "M"

I am trying with various combinations to write this formula I am not getting it through.

I appreciate your help to me on this issue.

TIA
GNaga

 

[dafan]

Put this in C10 conditionnal formatting, as formula:

=AND(A10="M",C1="A")

 

[gnaga]

Thanks for your effort and time. It works fine.

GNaga