View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
richzip richzip is offline
external usenet poster
 
Posts: 74
Default Conditional format

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