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
<tbody>
</tbody>
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?
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
N | O | Q | True = Working, False = Not Working | |
Row273 | 0 | 750 | 750 | True |
Row274 | 0 | 750 | 675 | True (Bold = Highlight) |
Row275 | 750 | 0 | 750 | True but False (Bold = Highlight) |
Row276 | 750 | 750 | 1500 | True but False (Bold = Highlight) |
<tbody>
</tbody>
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?