format cells in one column based on value in another column

[SuzyQ]

I want to highligt the value in one cell if the value of another cell in the
same row is null. (Unless value is 0) I want this format for every cell in
one column. How can I do this? Additionally, for another column I want to
do the same thing.

In the example below I want to highlight D1, D4, D5, E1, and E4 because G1
and G4 are null - Rows 2 and 3 would not be highlighted because column G in
those rows have a value. E5, D6, and E6 would not be highlighted because
their value is 0. I want to do this for the entire column of D and E. Do I
have to do this individually in each cell of those column, or is there
another way? What would the formula be, because I tried it for one cell (D1)
using the formula isnull(G1), but it put cell value = "isnull(G1)" instead.

Columns
D E G
23.67 0.33
6.89 0.11 7/16/09
16.07 0.93 7/7/9
14.08 0.92
10 0
0 0

 

[Per Jessen]

Hi
Select both columns, and use this formula in conditional formatting:

=AND($G1="",D1<>0)

Regards,
Per

 

[SuzyQ]

I probably should have included version is 2007

 

[SuzyQ]

thanks - it worked perfectly

Hi
Select both columns, and use this formula in conditional formatting:

=AND($G1="",D1<>0)

Regards,
Per