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

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

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

Regards,
Per

"SuzyQ" skrev i meddelelsen
...
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

thanks - it worked perfectly

"Per Jessen" wrote:

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

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

Regards,
Per

"SuzyQ" skrev i meddelelsen
...
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

I probably should have included version is 2007

"SuzyQ" wrote:

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