Calgarypuck Forums - The Unofficial Calgary Flames Fan Community - View Single Post

Boblobla · 01-30-2016, 09:20 AM

HA, got it.

I needed to use an AND statement in conditional formatting.

=and(A1="Y", isblank(B1))

the condition is change the cell to red and the range is the full column and it works.

01-30-2016, 09:20 AM	#4
Boblobla Franchise Player Join Date: Apr 2008 Location: Calgary Exp:	HA, got it. I needed to use an AND statement in conditional formatting. =and(A1="Y", isblank(B1)) the condition is change the cell to red and the range is the full column and it works.