Conditional formatting

[Jay]

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
___

 

[macropod]

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.

 

[Bob Greenblatt]

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
___

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.

 

[William Loring]

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

 

[Bob Greenblatt]

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

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.