Conditional formatting isn't correct for some cells

[daviddaich]

I'm trying to do some simple color formatting by comparing multiple cell's values to the value in the Goal cell. If higher, green. It's working form most cells in the uploaded example below, but not for M5, N5, and P5. I've tried everything, but can't get it to work. All cells are the same number format. Does anyone know why this conditional formatting rule doesn't work properly?

[TMS]

How would you expect anyone to diagnose a problem with an Excel workbook using a Word document with a picture of part of a worksheet and a dialogue box?

[daviddaich]

Well, I was hoping it was just something silly I messed up that someone would spot from the screenshot. But here's the spreadsheet.

[TMS]

Cell value > $C5, not just C5

Unless you make the column absolute, you will just be comparing each value to the value in the previous column.

Regards, TMS

[daviddaich]

That did it. Thank you.

[TMS]

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.