Conditional Formatting and blank fields

[Pumpk1n]

I have an incoming CSV file which has blanks where no data exists. When I apply conditional formatting using the EXCEL functionality (i.e. where cell value is greater than a specific value), the blank rows are also shaded. There are different columns -- one is formatted as "accounting" and the other is formatted as "custom" but neither treats the CSV value as 0. I'd like those blank CSV fields treated as 0 so they don't meet the criteria. Is there a way to do tha within existing conditional formatting functionality?

 

[Toadstool]

Hi Pumpk1n,

Have you tried and AND statement to also check for a null cell?

csv2.csv
	D	E
1	Value1	Value2
2	7
3		55
4	333	0
5	0	22
csv2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D2:E5	Expression	=AND(D2<>"",D2>0)	text	NO

 

[Pumpk1n]

I don't believe I can apply that formula based on what I see in the formatting selection box. Can you confirm.

 

[Toadstool]

Pumpk1n,

You need to select the formula option