View Single Post
  #1  
Old August 24th, 2005, 10:01 PM
anjgoss
external usenet poster
 
Posts: n/a
Default "BLANK" - need to delete


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