Conditional Formatting
 

I'm attempting to do some conditional formatting on text. I need to
highlight cells that contain the word missing and also any cells that were
left blank.

is this possible?

Conditional Formatting
 

Select the cells you want to assign conditional formatting to and click
FORMAT in the menu and select CONDITIONAL FORMATTING:

Drop down the options in the CONDITION 1 combo box and select FORMULA IS

In the text box to the right enter the following formula, replacing A1 with
the currently active cell in your selected range:

=OR(A1="",A1="missing")

Click the format button and then select the formats you want to apply and
click OK twice to exit back to the worksheet
--
Kevin Backmann


"watermt" wrote:

I'm attempting to do some conditional formatting on text. I need to
highlight cells that contain the word missing and also any cells that were
left blank.

is this possible?

Conditional Formatting
 

Highlight all the cells you want this to apply to (assume the first of
these is A1), then click on Format | Conditional Formatting and in the
dialogue box choose Formula Is rather than Cell Value Is in the first
box. Enter this formula in the next box:

=OR(A1="",ISNUMBER(SEARCH("missing",A1)))

Click on the format button and the Patterns Tab to choose your
highlight colour. Click OK (twice) to apply these settings - Excel
will automatically adjust the cell references to suit your selected
cells, but if your first cell was not A1 then you will have to make
the appropriate changes to the formula I gave you.

Hope this helps.

Pete

On Jun 24, 3:16*pm, watermt wrote:
I'm attempting to do some conditional formatting on text. *I need to
highlight cells that contain the word missing and also any cells that were
left blank.

is this possible?

Conditional Formatting
 

In Conditional Formatting, select "Formula Is", and try this:

=OR(A1="",COUNTIF(A1,"*missing*")0)

Assumes "missing" may be combined with other text in the same cell.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"watermt" wrote in message
...
I'm attempting to do some conditional formatting on text. I need to
highlight cells that contain the word missing and also any cells that were
left blank.

is this possible?

Conditional Formatting
 

I tried your suggestion and my conditional formatting ended up being applied
to every cell in the range. Thanks for the reply though!

"Kevin B" wrote:

Select the cells you want to assign conditional formatting to and click
FORMAT in the menu and select CONDITIONAL FORMATTING:

Drop down the options in the CONDITION 1 combo box and select FORMULA IS

In the text box to the right enter the following formula, replacing A1 with
the currently active cell in your selected range:

=OR(A1="",A1="missing")

Click the format button and then select the formats you want to apply and
click OK twice to exit back to the worksheet
--
Kevin Backmann


"watermt" wrote:

I'm attempting to do some conditional formatting on text. I need to
highlight cells that contain the word missing and also any cells that were
left blank.

is this possible?

Conditional Formatting
 

Kevin,
I went back and double checked your suggestion and realized that I had not
"cleared" my previous attempt at applying conditional formatting, so this is
why your suggestion dsiplayed all cells formatted. I corrected this and
still had a problem, only the cells labeld missing were formatted and your
formula overlooked the blank cells.

Mike

"Kevin B" wrote:

Select the cells you want to assign conditional formatting to and click
FORMAT in the menu and select CONDITIONAL FORMATTING:

Drop down the options in the CONDITION 1 combo box and select FORMULA IS

In the text box to the right enter the following formula, replacing A1 with
the currently active cell in your selected range:

=OR(A1="",A1="missing")

Click the format button and then select the formats you want to apply and
click OK twice to exit back to the worksheet
--
Kevin Backmann


"watermt" wrote:

I'm attempting to do some conditional formatting on text. I need to
highlight cells that contain the word missing and also any cells that were
left blank.

is this possible?

Conditional Formatting
 

Pete,
Thanks your suggestion worked, much appreciated!

Mike

"Pete_UK" wrote:

Highlight all the cells you want this to apply to (assume the first of
these is A1), then click on Format | Conditional Formatting and in the
dialogue box choose Formula Is rather than Cell Value Is in the first
box. Enter this formula in the next box:

=OR(A1="",ISNUMBER(SEARCH("missing",A1)))

Click on the format button and the Patterns Tab to choose your
highlight colour. Click OK (twice) to apply these settings - Excel
will automatically adjust the cell references to suit your selected
cells, but if your first cell was not A1 then you will have to make
the appropriate changes to the formula I gave you.

Hope this helps.

Pete

On Jun 24, 3:16 pm, watermt wrote:
I'm attempting to do some conditional formatting on text. I need to
highlight cells that contain the word missing and also any cells that were
left blank.

is this possible?

Conditional Formatting
 

RD,
Your formula and Pete's both worked as I had wished, thanks!

"RagDyeR" wrote:

In Conditional Formatting, select "Formula Is", and try this:

=OR(A1="",COUNTIF(A1,"*missing*")0)

Assumes "missing" may be combined with other text in the same cell.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"watermt" wrote in message
...
I'm attempting to do some conditional formatting on text. I need to
highlight cells that contain the word missing and also any cells that were
left blank.

is this possible?

Conditional Formatting
 

You're welcome, Mike - thanks for feeding back.

Pete

On Jun 24, 4:01*pm, watermt wrote:
Pete,
Thanks your suggestion worked, much appreciated!

Mike



"Pete_UK" wrote:
Highlight all the cells you want this to apply to (assume the first of
these is A1), then click on Format | Conditional Formatting and in the
dialogue box choose Formula Is rather than Cell Value Is in the first
box. Enter this formula in the next box:

=OR(A1="",ISNUMBER(SEARCH("missing",A1)))

Click on the format button and the Patterns Tab to choose your
highlight colour. Click OK (twice) to apply these settings - Excel
will automatically adjust the cell references to suit your selected
cells, but if your first cell was not A1 then you will have to make
the appropriate changes to the formula I gave you.

Hope this helps.

Pete

On Jun 24, 3:16 pm, watermt wrote:
I'm attempting to do some conditional formatting on text. *I need to
highlight cells that contain the word missing and also any cells that were
left blank.

is this possible?- Hide quoted text -

- Show quoted text -

Conditional Formatting
 

Is there a limit to how many arguments I can use with your formula?

"Pete_UK" wrote:

Highlight all the cells you want this to apply to (assume the first of
these is A1), then click on Format | Conditional Formatting and in the
dialogue box choose Formula Is rather than Cell Value Is in the first
box. Enter this formula in the next box:

=OR(A1="",ISNUMBER(SEARCH("missing",A1)))

Click on the format button and the Patterns Tab to choose your
highlight colour. Click OK (twice) to apply these settings - Excel
will automatically adjust the cell references to suit your selected
cells, but if your first cell was not A1 then you will have to make
the appropriate changes to the formula I gave you.

Hope this helps.

Pete

On Jun 24, 3:16 pm, watermt wrote:
I'm attempting to do some conditional formatting on text. I need to
highlight cells that contain the word missing and also any cells that were
left blank.

is this possible?

Conditional Formatting
 

I think OR can take up to 31 arguments.

Pete

On Jun 24, 4:08*pm, watermt wrote:
Is there a limit to how many arguments I can use with your formula?

Conditional Formatting
 

Appreciate the feed-back.
--

Regards,

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

"watermt" wrote in message
...
RD,
Your formula and Pete's both worked as I had wished, thanks!

"RagDyeR" wrote:

In Conditional Formatting, select "Formula Is", and try this:

=OR(A1="",COUNTIF(A1,"*missing*")0)

Assumes "missing" may be combined with other text in the same cell.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"watermt" wrote in message
...
I'm attempting to do some conditional formatting on text. I need to
highlight cells that contain the word missing and also any cells that were
left blank.

is this possible?