Is it possible?

[MattB]

Hi all

I have a s/sheet which gives me the product structure (Bill of Material) for numerous parent codes.
Column A shows Parent Code, B shows part code, C shows part description, D - part cost, E - Qty, F - Extended Cost.
Now having downloaded and FTP'd from the MRP system I then used Data>Subtotals to split all parents and give me a total underneath ext'd cost.
Great, but a few part codes have zero costs, so having sorted by ext'd cost the zeros sit at the bottom end of the structure.
Now all I need to do is flag them somehow so it is apparent that the cost is incomplete.
Is it possible to run a code or do anything else that will highlight the complete Row if the figure in column D is zero?
Sorry if that was a little longwinded!!

[Ian Mac]

On 2002-04-03 05:52, MattB wrote:
Hi all

I have a s/sheet which gives me the product structure (Bill of Material) for numerous parent codes.
Column A shows Parent Code, B shows part code, C shows part description, D - part cost, E - Qty, F - Extended Cost.
Now having downloaded and FTP'd from the MRP system I then used Data>Subtotals to split all parents and give me a total underneath ext'd cost.
Great, but a few part codes have zero costs, so having sorted by ext'd cost the zeros sit at the bottom end of the structure.
Now all I need to do is flag them somehow so it is apparent that the cost is incomplete.
Is it possible to run a code or do anything else that will highlight the complete Row if the figure in column D is zero?
Sorry if that was a little longwinded!!

You could use Conditional Formating under the Format Menu.

if you data starts in row 1 highlight the whole area (Important! highlight top left to bottom right).

Open the Conditional Formating and change the Cell Value Is to Formula is and put:

=AND($D1=0,LEN($D1)>0)

it's important to use the $ as they are.

Click the Format button a select how you'd like it.

any probs let me know.

[MattB]

Splendid!
Thanks - I knew how to highlight selected cells using cond.format. but not the whole row.