Thread: Cond. Formatting; If Cell B6 or B7 is blank I want Cell D12 to be
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dr. Darrell Dr. Darrell is offline
external usenet poster
  
Posts: 74
Default Cond. Formatting; If Cell B6 or B7 is blank I want Cell D12 to be
I have a formula in Cell D12:

=SQRT(POWER($B$6,2)+POWER(B$7,2))

If in have no entry in Cell B6 or B7, I would like cell D12 to be blank.

I think it should be done with Conditional Formatting, but how do I identify
or recognize a blank (no entry) cell?
Reply With QuoteReply With Quote