Conditional Formatting with OR: statement isn't working with two conditions

[draidr]

I have 3 Cells I'm working with. N, O, Q

My Conditional Formatting Formula is as follows: =OR($N260+$O260<>$Q260,$O260<>$Q260)
The conditional format is in Column Q applying to cells 260-325. I want to Highlight any cell within $Q$260:$Q$325 YELLOW if any number other than $O260=$Q260 OR the sum of $N260+$O260=$Q260

If conditions are met, It's supposed to Highlight YELLOW.
(For additional reference, I have another condition for blanks to null out the above formula)

The problem I'm facing is, the formula is working fine if O=Q (IE O273=Q273) and the adjoining N cell is 0. Q273 is normal and everything is fine. If Q276 is the =SUM(N276,O276) and N276 has any number other than 0 in it, Q276 is highlighted Yellow every time.

Here is a reference table of my problem

[TABLE="class: grid, width: 600, align: center"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]N[/TD]
[TD="align: center"]O[/TD]
[TD="align: center"]Q[/TD]
[TD="align: center"]True = Working,
False = Not Working[/TD]
[/TR]
[TR]
[TD="align: center"]Row273[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]750[/TD]
[TD="align: center"]750[/TD]
[TD="align: center"]True[/TD]
[/TR]
[TR]
[TD="align: center"]Row274[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]750[/TD]
[TD="align: center"]675[/TD]
[TD="align: center"]True
(Bold = Highlight)[/TD]
[/TR]
[TR]
[TD="align: center"]Row275[/TD]
[TD="align: center"]750[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]750[/TD]
[TD="align: center"]True but False
(Bold = Highlight)[/TD]
[/TR]
[TR]
[TD="align: center"]Row276[/TD]
[TD="align: center"]750[/TD]
[TD="align: center"]750[/TD]
[TD="align: center"]1500[/TD]
[TD="align: center"]True but False
(Bold = Highlight)[/TD]
[/TR]
</tbody>[/TABLE]

I don't know why the conditional formula isn't working but it should. Can anyone provide assistance as to what I'm doing wrong?

 

[Special-K99]

Try

=OR($N260+$O260<>$Q260,AND(COUNTIF(O260:O325)<>0,O260<>$Q260))

 

[revcanon]

Actually, the conditional formatting is working as you typed it.

Because it is looking to meet only 1 of the 2 requirements to highlight it yellow, you will always have a highlighted cell in Q unless N is 0 or blank and O=Q.

If O=Q, no highlight, but if N <> 0 or blank also, then N+O will never equal Q..... HIGHLIGHT

If N+O=Q, no highlight, but if O<>Q.... HIGHLIGHT


Try Special-K99's formula above to see if that is what you are looking for.

 

[draidr]

Try

=OR($N260+$O260<>$Q260,AND(COUNTIF(O260:O325)<>0,O260<>$Q260))

Ok, I see what you're talking about revcanon,
The code does in fact work... but not the way I intended. It is only looking for one of the requirements. Bahh

Special-K99's code says there are too few arguments and everything I've done thus far to edit it similar to that doesn't seem to work.

I'm still back to my original problem.

 

[draidr]

I didn't get a response to my above question. In fact, I'm still puzzled by the whole COUNTIF looking at the cells below "O".
However, I figured out the conditional formula in a much simpler way. I was overthinking it because there were two criteria.

Solution: Select entire Column Q.
Insert Conditional Formatting > New Rule > Use a Formula: =($N1+$O1=$Q1)=FALSE
Format > Fill Yellow.