View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dana DeLouis Dana DeLouis is offline
external usenet poster
 
Posts: 947
Default Cond. Formatting; If Cell B6 or B7 is blank I want Cell D12 tobe

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

Just to mention a slightly shorter version...

=SQRT(SUMSQ($B$6,$B$7))

- - -
HTH
Dana DeLouis


Dr. Darrell wrote:
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?