Highlight formula assistance

[rn119]

I need a formula to highlight the cell right above if a cell in a specific column (let's say Column C) has a unique text value (e.g., IP). Any assistance would be appreciated.

 

[rn119]

I adjusted your formula to 19000 rows but it doesn't appear to be working. Looks like it's highlighting random cells along with cells that have the text value. I'm wondering if the D3 cell reference is causing the issue?

=AND(COUNTIF(D2:D19000,"*")-COUNTIF(D2:D19000,LOOKUP(2,1/(D2:D19000<>""),D2:D19000))=0,D2="",D3<>"")

 

[Joe4]

I'm wondering if the D3 cell reference is causing the issue?

Nope, it shouldn't be, if you entered it correctly. When you apply a Conditional Formatting formula to a range of cells, you write the formula as it applies to the first cell in your selected range, and it will adjust it for all the other cells.

Are you physically selecting cells D2:D19000 before applying this formula (being sure NOT to select row 1)?
If not, how exactly are you selecting the cells?