Conditional Formatting based on multiple criteria

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.

Use a formula of

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

--

HTH

Bob Phillips

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

<[email protected]> wrote in message
news:[email protected]...
> 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.
>

Try this:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
<[email protected]> wrote in message
news:[email protected]...
>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.
>