| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula in excel that will highlight a cell that is left blank?
I'm trying to find a formula to make a certain cell if it is left blank to be
able to highlight it with a color. Anyone have any ideas? Thanks Kimo |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula in excel that will highlight a cell that is left blank?
One way is conditional formatting. If your cell is B10, Format
menu/Conditional formatting. Under condition 1, select formula. In the box to the right type =isblank(B10) Then select format .... below the formula box. Then select the patterns tab. Select the color you want the cell to be if it is blank. .. "Kimo" wrote in message ... I'm trying to find a formula to make a certain cell if it is left blank to be able to highlight it with a color. Anyone have any ideas? Thanks Kimo |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula in excel that will highlight a cell that is left blank?
The cell will be highlighted until something (anything, except a formula
blank) is entered. Assume the cell of interest is A1 Select cell A1 Goto the menu FormatConditionalFormatting Formula is: =A1="" Click the Format button Select the style(s) desired (maybe a red fill color) OK out -- Biff Microsoft Excel MVP "Kimo" wrote in message ... I'm trying to find a formula to make a certain cell if it is left blank to be able to highlight it with a color. Anyone have any ideas? Thanks Kimo |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula in excel that will highlight a cell that is left blank
Thanks for your input.
"T. Valko" wrote: The cell will be highlighted until something (anything, except a formula blank) is entered. Assume the cell of interest is A1 Select cell A1 Goto the menu FormatConditionalFormatting Formula is: =A1="" Click the Format button Select the style(s) desired (maybe a red fill color) OK out -- Biff Microsoft Excel MVP "Kimo" wrote in message ... I'm trying to find a formula to make a certain cell if it is left blank to be able to highlight it with a color. Anyone have any ideas? Thanks Kimo |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula in excel that will highlight a cell that is left blank
Hey Thanks Dave, worked great.
"Dave Thomas" wrote: One way is conditional formatting. If your cell is B10, Format menu/Conditional formatting. Under condition 1, select formula. In the box to the right type =isblank(B10) Then select format .... below the formula box. Then select the patterns tab. Select the color you want the cell to be if it is blank. .. "Kimo" wrote in message ... I'm trying to find a formula to make a certain cell if it is left blank to be able to highlight it with a color. Anyone have any ideas? Thanks Kimo |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting:highlight row based on blank or non-blank c | Excel Worksheet Functions | |||
| I want to use a formula in excel to highlight a cell 30 days prio | Excel Worksheet Functions | |||
| Can I set up Excel highlight a non formula cell? | Excel Discussion (Misc queries) | |||
| Conditional Format to highlight blank cell | Excel Worksheet Functions | |||
| Excel VB-Copy formula down until adjacent cell (left) is blank? | Excel Discussion (Misc queries) | |||
Linear Mode
