Conditional Formatting of a row based on cell not working

Try changing I6 to $I6, that is, make the column absolute in your conditions.

You are referring to multiple columns. What you don't see is that the CF formula will auto-adjust for each column in the range. So, column F will refer to column I as per your formula. Column G will refer to column J, column H will refer to column K, and so on. By making the column absolute (with the dollar sign), all the formulae will still refer to column I.




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.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.