Conditional format

[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

 

[Jacob Skaria]

--Select the range B2:B10..You can ignore cell B1 since that will never
satisfy the condition. Please note that in the selection B2 is the active
cell and apply the below formula..
=AND(A1=A2,B1<>"",B2="")

If this post helps click Yes