Hi guys,

I have a column A2:A20 where I have the values Yes or No listed. If I have a 'Yes' in A2, I want cell B2 to be 'red' if it is blank and has no value (Column B2:B20 is where I will input something if someone has said yes). How can I write an IF statement to do this?

I hope I`m on the right track!

Thank you