Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Format overwrighting previous conditional format | Excel Programming | |||
New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
Multiple conditional on conditional format formula | Excel Programming | |||
Multiple conditional on conditional format formula | Excel Programming | |||
Keep format after paste from other worksheets - conditional format or EnableControl solution doesn't work | Excel Programming |