Suppose your value is in column A. Then select column B and go to conditional
formattting. Condition 1: select "Formula Is" and type =$a2="YES". Click on
Format button and change the color into green. Condition 2: select "Formula
Is" and type = $a2<"YES". Click on Format button and change the color into
Red. This works

"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