| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting to test blank text cell | Excel Worksheet Functions | |||
| blank spaces in front of a number prevents formatting cell | Excel Discussion (Misc queries) | |||
| put zero in blank cell using conditional formatting | Excel Worksheet Functions | |||
| Multiple formatting in text cell blank it out! | Excel Discussion (Misc queries) | |||
| conditional formatting blank cell | Excel Discussion (Misc queries) | |||
Threaded Mode
