Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional format
--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 --------------- Jacob Skaria "richzip" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |