I have a spreadsheet where I have tasks, and I prioritize those tasks based on high, medium, and low levels. I currently use conditional formatting for this, so if I select from a drop-down "HIGH", the whole row will be highlight red.
However. I would like to add another condition, for the same row. I want to now click the checkbox indicating that this task is complete, and once I do, it would change to another color.
I tried using the
AND formula, but I think that the conditions compete against one another, so even when I click the checkbox, the row will still stay red because of the priority condition.
What can I do?