Conditional Formatting based on multiple criteria

[twlove]

I want to conditionally format blank cells in column B to blue when the
value in corresponding cells in column A contain the word "Custom".
However, once I place a value in a blank highlighted cell in column B I
then want the formatting removed.

Example:

Row 2 - - Cell A = "Custom" - - Cell B is blank - - therefore cell B2
turns blue

Then

Row 2 - - I enter a value in cell B2 - - the blue formatting goes away.

 

[Bob Phillips]

Use a formula of

=AND(B2="",A2="Custom")

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

 

[Ragdyer]

Try this:

=AND(A2="Custom",B2="")