IF function result and conditional formatting

[rayted]

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

[PaulM100]

Formula for conditional formatting:
=AND(A1="Yes",B1="")

[rayted]

Thank you Paul.

Is it possible to write a rule for the same range to say if B1 is not blank, format it in a different colour?

[PaulM100]

=AND(A1="Yes",B1<>"") and select another colour in conditional formatting rule

[rayted]

Hi Paul

I am seeing '0' appear in B2 when I input the formula. Should this be the case?

Please see attached.

Thank you

[PaulM100]

That's not how you apply conditional formatting. Check the link below on how to set it up. At step 4 add the formula from above.
https://support.office.com/en-us/art...b-f1951ff89d7f