| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
in excel: format font conditional on content of adjacing cell?
Excel 2003
I wish to underline the content of one cell, if the adjacing cell is empty. Both cells may or may not contain text only (not formulas). |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
in excel: format font conditional on content of adjacing cell?
"carl87" wrote in message
... Excel 2003 I wish to underline the content of one cell, if the adjacing cell is empty. Both cells may or may not contain text only (not formulas). To underline A2 if A1 is empty, conditionally format A2 with this formula: =(A1="") |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
in excel: format font conditional on content of adjacing cell?
If your 'adjacing' cell is A1 and the cells you want to format is B1
then: Select B1 Click Format Click Conditional Formatting... Change 'Cell Value Is' to 'Formula Is' Enter formula =A1="" Click on the Format... button Change underline from 'None' to 'Single' Click OK Click Ok You can copy/paste formats this to any other cell apart from the whole of column A. Giff |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excel, conditional format (font red) referencing another cell? | Excel Worksheet Functions | |||
| Conditional Formatting if cell content is a formula | Excel Worksheet Functions | |||
| Conditional cell background formatting, based on cell content | Excel Discussion (Misc queries) | |||
| In Excel, how can i see all tabs in format cell - I only see font. | Excel Discussion (Misc queries) | |||
| Conditional format if cell=0 then font colour same as background . | Excel Discussion (Misc queries) | |||
Linear Mode
