Conditional Formatting - Not working in odd cells where it should be???? I have

Question

Conditional Formatting - Not working in odd cells where it should be????

I have a sheet where I'd applied the same rule to different blocks of numbers in the same column (I can't remember why I did it this way, all I can think is that because I'm not very good with conditional formats I did them all separately).

Now I've tried to use a single rule to cover them all to make it a neater sheet. However, for some reason the rule isn't working for odd cells where is should / has in the past using the old multiple series of rules. I can't figure out why.

The rule I'm using is: =AND(I5=W5,I5<>"") highlight green, see screenshot.

I've applied a screenshot below of where the error is occurring. It's also happening in 1 cell above, which is in the middle of cells that are highlighted correctly.

I added the condition by highlighting the entire column W and entering the row number for the first cell that I want the rule to apply to (row 5).

Any ideas what I'm doing wrong?

Cheers.

Explanation / Answer

Hello

try

My guess would be that in the rows that aren't getting formatted to values aren't the same as they appear in the cell. Try this for a pair of cells you think should be formatted.

=I20=W20

That has to return TRUE for the cell to be formatted and if it returns FALSE then the values aren't the same. You could try this CF formula.

=AND(ROUND(I5,2)=ROUND(W5,2),I5<>"")

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.