Forum Discussion
Conditional Formatting Not Working
I am trying to create a conditional formatting rule which would highlight the cell in column P if there is a value in column K and Column P="No". The formula I used for the rule is: =AND(NOT(ISBLAN...
It is highlighting the cell about it not the actual cell. This is so strange! I have never seen something like this happen. I am usually so good with formulas and conditional formatting
Hello again.
The formula uses relative row references. They are relative to the position of the active cell when the format was defined. Looks like the active cell may have been not in row 2 if it is highlighting a cell in a row above. Fix it this way:
- Delete the wrong formatting rule and start a new one.
- Make sure to select cell P2 and use the formula from above.
- Or if you select cell P3, you need to adjust the formula to look at the cells in row 3, not row 2.