Conditional Formatting based on multiple criteria

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

twlove@ontuet.com - 03 Aug 2006 21:25 GMT

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.

Reply to this Message

Bob Phillips - 03 Aug 2006 21:31 GMT

Use a formula of

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

--

HTH

Bob Phillips

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

> 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".
[quoted text clipped - 9 lines]
>
> Row 2 - - I enter a value in cell B2 - - the blue formatting goes away.

Reply to this Message

Ragdyer - 03 Aug 2006 21:37 GMT

Try this:

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

Signature

HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

>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".
[quoted text clipped - 9 lines]
>
> Row 2 - - I enter a value in cell B2 - - the blue formatting goes away.

Reply to this Message