R
richzip
Hello,
I would like to set up conditional formatting for the following:
If the value in Row n, Column A equals the value in the row above it (n-1),
Column A--AND the value in row n, Column B is blank--AND the value in row
(n-1), Coumn B is NOT blank--then Row n, Column B should be highlighed.
In the example below: B3 should be higlighted, since A3 = A2, AND B3 is
blank, and B2 is NOT blank.
B5 is not highlighted, because B5 <> B4-- and B6 is not highlighted, becuase
even though B6 = B5, B5 is blank.
A B
1 60 95
2 60 95
3 60
4 60
5 61
6 61
7 61
I would like to set up conditional formatting for the following:
If the value in Row n, Column A equals the value in the row above it (n-1),
Column A--AND the value in row n, Column B is blank--AND the value in row
(n-1), Coumn B is NOT blank--then Row n, Column B should be highlighed.
In the example below: B3 should be higlighted, since A3 = A2, AND B3 is
blank, and B2 is NOT blank.
B5 is not highlighted, because B5 <> B4-- and B6 is not highlighted, becuase
even though B6 = B5, B5 is blank.
A B
1 60 95
2 60 95
3 60
4 60
5 61
6 61
7 61