formatconditional formatetc

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Paoul" wrote in message
...
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