Conditional format

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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top