Conditional formatting for blank rows

[detriez]

Excel does this thing when you clear the cells in a row, the rows remain behind.. We call them ghost records.

To recreate, add data randomly to a sheet, then select the cells (not rows) and click delete
Now, select the the entire sheet and F5 ... "Special.. Blanks. and these rows will be selected

My question is, how can I use conditional formatting to highlight those rows?

 

[JoeMo]

This example uses CF to highlight blank cells among data-containing cells. Is this what you want?

Book1
	A	B	C	D	E	F	G	H	I	J
1	Hdr1	Hdr2	Hdr3	Hdr4	Hdr5	Hdr6	Hdr7	Hdr8	Hdr9	Hdr10
2		data	data	data		data	data		data	data
3	data		data	data	data	data	data	data	data	data
4	data	data		data	data	data	data	data	data	data
5	data	data	data		data	data	data	data	data	data
6	data	data	data	data		data	data	data	data	data
7	data	data	data	data	data		data	data	data	data
8	data	data	data	data	data	data		data	data	data
9	data	data	data	data	data	data	data		data	data
10	data	data	data	data	data	data	data	data		data
11	data	data		data	data	data	data	data	data
12	data	data	data	data	data	data	data	data	data	data
13	data	data	data	data	data	data	data	data	data	data
14	data	data	data	data	data	data	data	data	data	data
15	data	data	data	data	data	data	data	data	data	data
16	data	data	data	data		data	data	data	data	data
17	data	data	data	data		data	data	data	data	data
18	data	data	data	data		data	data	data	data	data
19	data	data	data	data	data	data	data			data
20	data	data	data	data	data	data	data	data	data	data
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:J20	Expression	=ISBLANK(A1)	text	NO