Conditional Formatting Formula Problem

Here is the formula I am trying to use. I want the cell to turn yellow.

=OR($F869="TEXT A",$F869="TEXT B",$F869="TEXT C")AND($Q869="")

The OR statement works, but I can't get the AND statement to work. The cell(Q869) turns yellow even though the cell is not blank.

Please help.

Originally Posted by Special-K

try

=AND($Q869="",OR($F869="TEXT A",$F869="TEXT B",$F869="TEXT C"))

AND has precedent over OR

also if you're ANDing then logically you must have at least TWO things to AND against.

This may also work depending on your data.

=AND($Q869="",LEFT($F869,4)="TEXT")

Thanks, but that doesn't seem to work. I only want the cell(Q869) turn yellow when two conditions are met. When F869 has one of three options selected and Q869 is blank. The formula you suggested highlights the cell, even if none of the three options are selected.

Would ISBLANK be an option for capturing the blank cell? Am I making any sense?

I believe your first solution does work, and I thank you very much for that.

I believe the problem was in my absolute reference of Q869, when trying to copy the format.