Forum Discussion
Highlighting a cell different from the formula cell
I am attempting to use conditional formatting in one cell (a protected cell) and have it highlight a different cell (an unprotected cell). The reason for this is I want the cell with the formula to b...
.png){kind=link}
.png){kind=link}
I hope you are well.
If I understand your question right, I would suggest that you place the Conditional formatting and formula in cell P5 where you want the cell to change if it meets the condition (click onto cell P5 and apply your formatting there).
Also for house keeping, I think the first part of your formula is unnecessary A5<>"" as the next criteria is A5>4. So unless A5>4 happens, the condition isn't met anyway. It doesn't affect your outcome though but just pointing it out.
I've attached a sample spreadsheet with the working formula.
If I have not understood you right, please let me know?
Best wishes!
Cheers
Damien