I want to format a cell based on the value of anither cell.

ie

If I9 = "yes" then format B9 as Bold Green

Anybody help - I've tried a few variation but can't get it to work.

Cheers