I can do it for same cells but i cant seem to find a way to do it so it
changes a different cell. The rules in the conditional formatting seems to be
stuck to particular cells

"Paoul" wrote:

I want a cell to change its colour to green when another cell has yes in itl.
If it does not have yes in it i want it to be red. Ive tried using the iF
function but i dont know how it works and i keeep getting errors

Help is appreciated :)

Thank you