when using a pivot - the word "BLANK" transfers in when the data sheet
has a blank area...
How can I get that to be just blank so that I can use that cell in a
conditional formatting scenario?
I want to say...
=IF(Q8="blank")
if Q8 is blank, then turn red
if Q8 has a value, then turn green
Angela
--
anjgoss
------------------------------------------------------------------------
anjgoss's Profile:
http://www.excelforum.com/member.php...o&userid=26602
View this thread:
http://www.excelforum.com/showthread...hreadid=398765