 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / May 2008Formating cells
Is there a way to utomatically remove boarder if there is no value in the cell and place a boarder i there is? Hi, yes put a border round the cell as normal then use conditional formatting - cell value is 0 (or use a formula to test if the cell isblank) & set the conditional format to no border  Signature-------------------------------------------- Please reward mine and others efforts - indicating whether our posts were helpful by clicking the buttons, ta > Is there a way to utomatically remove boarder if there is no value in the > cell and place a boarder i there is? Thanks DazzData, did not get what you said. i figured it out eventually, so thanks for your help. > Hi, > [quoted text clipped - 4 lines] > > Is there a way to utomatically remove boarder if there is no value in the > > cell and place a boarder i there is? Select the cell or cells you want this functionality on (if you select more than one cell, note which one is the active cell) and click Format/Conditional Formatting in Excel's menu bar. On the dialog box that appears, select "Formula Is" from the first drop down and put this formula in the second field... =LEN(A1)>0 NOTE: Change the A1 reference to the address of the cell (or, in the case of multiply selected cells, the address for the active cell). Next, click the Format button and then select the Border tab on the next dialog box that appears. Select the type of outlining you want (you can also select other format options from the other tabs if you wish) and then OK your way back to the worksheet. Whenever you enter something into that cell (or one of the cells from the multiple selection), the border option you picked will appear. Rick > Is there a way to utomatically remove boarder if there is no value in the > cell and place a boarder i there is? thanks for your help Rick, was a little confusing at first, but i figured it out. > Select the cell or cells you want this functionality on (if you select more > than one cell, note which one is the active cell) and click [quoted text clipped - 18 lines] > > Is there a way to utomatically remove boarder if there is no value in the > > cell and place a boarder i there is? Format>Conditional Formatting>Formula is: =NOT(ISBLANK(cellref)) Format>Border Gord Dibben MS Excel MVP >Is there a way to utomatically remove boarder if there is no value in the >cell and place a boarder i there is? Thanks for your response Gord. I figured it out by a combination of all the replies. All of them as a single comment where confusing but put together they made sense, thanks. > Format>Conditional Formatting>Formula is: > [quoted text clipped - 6 lines] > >Is there a way to utomatically remove boarder if there is no value in the > >cell and place a boarder i there is? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.