conditionally format the first value to the right of a blank cell

[skoehler9]

I want to highlight the first cell with a value that applies to the left of a blank. Any ideas?

Thanks,

[ChemistB]

Select your range, Let's say B2:Z100
Conditional Formatting> New Rule>Use Formula
=AND(ISBLANK(B1),NOT(ISBLANK(B2)))
Does that work for you? It should if they are truly blanks

EDIT: Opps, got my lefts and rights mixed up
With same range,
=AND(ISBLANK(B3),NOT(ISBLANK(B2)))

[NBVC]

Assuming you want to highlight column F where first occurance of blank cell in G.

Select column F and Home|Conditional formatting|New Rule

use a formula to determine which cells to format

enter: =COUNTIF(G$1:G1,"")

click Format and choose...

[skoehler9]

Doesn't seem to work.

[NBVC]

Here is my interpretation.. only first cell to left of a blank is highlighted.

[skoehler9]

Assuming you want to highlight column F where first occurance of blank cell in G.

Select column F and Home|Conditional formatting|New Rule

use a formula to determine which cells to format

enter: =COUNTIF(G$1:G1,"")

click Format and choose...

I have a range of cells that is going to be expanding. A blank can occur anywhere in the range. I would like to highlight any cell that contains a value and that has a blank to the left of it. There could be several blanks in a row with non blank items mixed in. I don't want to highlight cells that have a value to the left of it, but have a blank farther to the left. I hope I have explained it clearly.

[skoehler9]

I am trying to highlight the first occurance of a value in the baseline field of this book.

[ChemistB]

Okay, I used a range of D2:X50 and applied this condition

=AND(ISBLANK(E2),NOT(ISBLANK(D2)))
See attachment. Is that what you are looking for?

[skoehler9]

That is close. It seems to be checking for a blank to the right of a cell instead of to the left of a cell. Everything else seems to be the way I would like it. Thanks.

[ChemistB]

Okay, change the conditional formatting formula to

=AND(ISBLANK(C2),NOT(ISBLANK(D2)))
Does that work for you?

[skoehler9]

That works perfectly... Thank you very much to everyone that was helping.