Conditional formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jay - 07 Jun 2006 07:25 GMT

I am trying to conditionally format a range of cells - simply filling them
in grey if they are empty. However, they contain the following:

=If(A1>0,A1/B1,"")

What condition can I use to fill this cell if indeed it contains "" ?

Many TIA

Jay
___

Reply to this Message

macropod - 07 Jun 2006 10:01 GMT

Hi Jay,

=A1=""

where A1 is the cell you want to test, should do it.

Cheers
PS: posting new questions in existing threads gives you less chance of
getting an answer.

Signature

macropod
[MVP - Microsoft Word]

> I am trying to conditionally format a range of cells - simply filling them
> in grey if they are empty. However, they contain the following:
[quoted text clipped - 7 lines]
> Jay
> ___

Reply to this Message

Bob Greenblatt - 07 Jun 2006 14:17 GMT

On 6/7/06 2:25 AM, in article C0AC2FD4.1BCC%zeugma@toucanspam.com, "Jay"
<zeugma@toucanspam.com> wrote:

> I am trying to conditionally format a range of cells - simply filling them
> in grey if they are empty. However, they contain the following:
[quoted text clipped - 7 lines]
> Jay
> ___

It is more reliable to check for a null value by using the length of the
cell's value. So the condition in the conditional format should be
=len(a1)=0.

Signature

Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

Reply to this Message

William Loring - 28 Jul 2006 18:28 GMT

Here's my scenaraio:

I have one workbook with a set of products in it. Part numbers in the first
column, and lots of descriptive columns.

I have a second workbook (or could be a second sheet), which has a subset of
the part numbers only in the first column. No other data.

I'd like to set up some sort of conditional formatting that would highlight
the rows of part numbers in the master workbook that are also in the subset.

Is this possible? Does my description make sense?

Thanks for any help provided.

Regards,

William Loring

Reply to this Message

Bob Greenblatt - 28 Jul 2006 20:44 GMT

On 7/28/06 1:28 PM, in article C0EFC192.26057%bloring@tirerack.com, "William
Loring" <bloring@tirerack.com> wrote:

> Here's my scenaraio:
>
[quoted text clipped - 14 lines]
>
> William Loring

Yes, it does make sense. And yes it is possible. Normally conditional
formatting will not let you use a formula that refers to another worksheet
or workbook. However, you can "fool" it. Define a name in the first workbook
that refers to the range in the second workbook. Let's say the name you
defined is "XXX". Then use a conditional format with a formula of something
like:=match(a1,XXX,0)>0 and then set the format desired.

Signature

Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

Reply to this Message

Mac Forum / Applications / Excel / July 2006

Conditional formatting