Conditional formatting with countblank

[scott_86_]

Hi,

Could anyone please help me out with how to apply the countblank function to conditional formatting?

I'm looking to somehow convert the below if function into conditional formatting so that:

• TRUE will be green (=0)
• FALSE will be red (<>0)

=IF(COUNTBLANK(tbl_test[@[Column1]:[Column13]])=0,TRUE,FALSE)

 

[SunnyAlv]

no need if function, and i think u need 2 conditional formatting

conditional formatting 1 : (if tbl_test cells TRUE & set colour to Green)

tbl_test[@[Column1]:[Column13]])=0

conditional formatting 2 : (if tbl_test cells FALSE & set colour to RED)

tbl_test[@[Column1]:[Column13]])<>0

 

[Peter_SSs]

Try these formulas in Conditional Formatting

scott_86_.xlsm
	D	E	F	G	H	I	J	K	L	M	N	O	P
5	Column1	Column2	Column3	Column4	Column5	Column6	Column7	Column8	Column9	Column10	Column11	Column12	Column13
6	x	x	x	x	x	x	x	x	x	x	x	x	x
7	x	x	x	x	x	x	x	x	x	x		x	x
8	x	x	x	x	x	x	x	x	x	x	x	x	x
9
10
11	x	x	x	x	x	x	x	x	x	x	x	x	x
12	x	x	x	x	x	x	x	x	x	x	x	x	x
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D6:P12	Expression	=COUNTBLANK(INDIRECT("tbl_test[@[Column1]:[Column13]]"))>0	text	NO
D6:P12	Expression	=COUNTBLANK(INDIRECT("tbl_test[@[Column1]:[Column13]]"))=0	text	NO